Oracle 表结构：职位申请表创建及字段注释

CREATE TABLE job_application ( id NUMBER(10) PRIMARY KEY, deptid NUMBER(10), deptname VARCHAR2(50), jobname VARCHAR2(50), applyname VARCHAR2(50), salarydate DATE, wuserid NUMBER(10), createtime TIMESTAMP, createby VARCHAR2(50) );

COMMENT ON COLUMN job_application.id IS '申请ID'; COMMENT ON COLUMN job_application.deptid IS '部门ID'; COMMENT ON COLUMN job_application.deptname IS '部门名称'; COMMENT ON COLUMN job_application.jobname IS '岗位名称'; COMMENT ON COLUMN job_application.applyname IS '申请人姓名'; COMMENT ON COLUMN job_application.salarydate IS '薪资生效日期'; COMMENT ON COLUMN job_application.wuserid IS '申请人ID'; COMMENT ON COLUMN job_application.createtime IS '创建时间'; COMMENT ON COLUMN job_application.createby IS '创建人';