-- ----------------------------
-- 岗位信息表
-- ----------------------------
DROP TABLE IF EXISTS sys_post;

CREATE TABLE sys_post
(
    post_id     BIGSERIAL PRIMARY KEY,     -- 岗位ID，自增字段，主键
    post_code   VARCHAR(64) NOT NULL,      -- 岗位编码
    post_name   VARCHAR(50) NOT NULL,      -- 岗位名称
    post_sort   INT         NOT NULL,      -- 显示顺序
    status      CHAR(1)     NOT NULL,      -- 状态（0正常 1停用）
    create_by   VARCHAR(64)  DEFAULT '',   -- 创建者
    create_time TIMESTAMP,                 -- 创建时间
    update_by   VARCHAR(64)  DEFAULT '',   -- 更新者
    update_time TIMESTAMP,                 -- 更新时间
    remark      VARCHAR(500) DEFAULT NULL, -- 备注
);

COMMENT ON TABLE sys_post IS '岗位信息表';
COMMENT ON COLUMN sys_post.post_id IS '岗位ID';
COMMENT ON COLUMN sys_post.post_code IS '岗位编码';
COMMENT ON COLUMN sys_post.post_name IS '岗位名称';
COMMENT ON COLUMN sys_post.post_sort IS '显示顺序';
COMMENT ON COLUMN sys_post.status IS '状态（0正常 1停用）';
COMMENT ON COLUMN sys_post.create_by IS '创建者';
COMMENT ON COLUMN sys_post.create_time IS '创建时间';
COMMENT ON COLUMN sys_post.update_by IS '更新者';
COMMENT ON COLUMN sys_post.update_time IS '更新时间';
COMMENT ON COLUMN sys_post.remark IS '备注';

-- 初始化-岗位信息表数据
INSERT INTO sys_post (post_code, post_name, post_sort, status, create_by, create_time, update_by, update_time, remark)
VALUES ('ceo', '董事长', 1, '0', 'admin', CURRENT_TIMESTAMP, '', CURRENT_TIMESTAMP, ''),
       ('se', '项目经理', 2, '0', 'admin', CURRENT_TIMESTAMP, '', CURRENT_TIMESTAMP, ''),
       ('hr', '人力资源', 3, '0', 'admin', CURRENT_TIMESTAMP, '', CURRENT_TIMESTAMP, ''),
       ('user', '普通员工', 4, '0', 'admin', CURRENT_TIMESTAMP, '', CURRENT_TIMESTAMP, '');