Oracle创建表sql语句、注解、自增主键

CREATE TABLE datau_excel_audit_user(
  id number(11) primary key,
  audit_name VARCHAR2(20),
  iphone VARCHAR2(11),
  create_date DATE,
  update_date DATE
);

COMMENT ON TABLE datau_excel_audit_user IS '审批人管理';
COMMENT ON COLUMN datau_excel_audit_user.id  IS 'id';
COMMENT ON COLUMN datau_excel_audit_user.audit_name  IS '审核名字';
COMMENT ON COLUMN datau_excel_audit_user.iphone  IS '手机号码';
COMMENT ON COLUMN datau_excel_audit_user.create_date  IS '创建时间';
COMMENT ON COLUMN datau_excel_audit_user.update_date  IS '修改时间';


create sequence EXCEL_AUDIT_USER_SEQ
  minvalue 1
  nomaxvalue 
  start with 1;