«

pgsql创建表语句

---

时间：2025-7-11    作者：网络剑客    分类： other

---

CREATE TABLE department (
    id SERIAL PRIMARY KEY,
    department_id varchar(50),
    department_name varchar(100),
    superior varchar(50),
    parent_path varchar(50),
    status INT DEFAULT 1,
    created_at TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP
);

-- 添加注释（可选）
COMMENT ON TABLE department IS '部门信息表';
COMMENT ON COLUMN department.id IS '自增主键';
COMMENT ON COLUMN department.department_id IS '部门编号';
COMMENT ON COLUMN department.department_name IS '部门名称';
COMMENT ON COLUMN department.superior IS '上级部门ID';
COMMENT ON COLUMN department.parent_path IS '部门层级路径';
COMMENT ON COLUMN department.status IS '状态(0:禁用,1:启用)';
COMMENT ON COLUMN department.created_at IS '创建时间';
COMMENT ON COLUMN department.updated_at IS '更新时间';

标签: PostgreSQL