38 lines
1.9 KiB
SQL
38 lines
1.9 KiB
SQL
-- ============================================
|
||
-- 团课推荐表
|
||
-- ============================================
|
||
|
||
-- 团课推荐表
|
||
CREATE TABLE IF NOT EXISTS group_course_recommend (
|
||
id BIGSERIAL PRIMARY KEY,
|
||
course_id BIGINT NOT NULL,
|
||
recommend_title VARCHAR(200),
|
||
recommend_content TEXT,
|
||
recommend_reason VARCHAR(500),
|
||
priority INTEGER DEFAULT 0,
|
||
is_active BOOLEAN DEFAULT TRUE,
|
||
create_by VARCHAR(50),
|
||
update_by VARCHAR(50),
|
||
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
||
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
||
deleted_at TIMESTAMP
|
||
);
|
||
|
||
-- 创建索引
|
||
CREATE INDEX IF NOT EXISTS idx_group_course_recommend_course_id ON group_course_recommend(course_id);
|
||
CREATE INDEX IF NOT EXISTS idx_group_course_recommend_priority ON group_course_recommend(priority);
|
||
CREATE INDEX IF NOT EXISTS idx_group_course_recommend_is_active ON group_course_recommend(is_active);
|
||
|
||
COMMENT ON TABLE group_course_recommend IS '团课推荐表';
|
||
COMMENT ON COLUMN group_course_recommend.id IS '主键ID';
|
||
COMMENT ON COLUMN group_course_recommend.course_id IS '团课ID（关联group_course.id）';
|
||
COMMENT ON COLUMN group_course_recommend.recommend_title IS '推荐标题';
|
||
COMMENT ON COLUMN group_course_recommend.recommend_content IS '推荐内容';
|
||
COMMENT ON COLUMN group_course_recommend.recommend_reason IS '推荐理由';
|
||
COMMENT ON COLUMN group_course_recommend.priority IS '优先级（数字越大优先级越高）';
|
||
COMMENT ON COLUMN group_course_recommend.is_active IS '是否启用';
|
||
COMMENT ON COLUMN group_course_recommend.create_by IS '创建人';
|
||
COMMENT ON COLUMN group_course_recommend.update_by IS '更新人';
|
||
COMMENT ON COLUMN group_course_recommend.created_at IS '创建时间';
|
||
COMMENT ON COLUMN group_course_recommend.updated_at IS '更新时间';
|
||
COMMENT ON COLUMN group_course_recommend.deleted_at IS '删除时间（软删除）'; |