server/ses-manage/sql/2019-06/2019-06-19.sql

update frame_dict set dict_text='待主考学校审核提交' where dict_name='record_status' and dict_text='待主考学校审核';


-- Create table
create table pl_std_record_school
(
  id             number(10) not null,
  year_code      varchar2(6),
  join_school_id number(10),
  school_id      number(10),
  status         number(1)
)
;
-- Add comments to the table 
comment on table pl_std_record_school
  is '衔接学校上报情况表';
-- Add comments to the columns 
comment on column pl_std_record_school.year_code
  is '批次码,6位数字';
comment on column pl_std_record_school.join_school_id
  is '衔接学校ID，和机构表关联';
comment on column pl_std_record_school.school_id
  is '主考学校ID，和机构表关联';
comment on column pl_std_record_school.status
  is '上报状态；0：未上报，1：已上报';
-- Create/Recreate primary, unique and foreign key constraints 
alter table pl_std_record_school
  add constraint PK_STD_RECORD_SCHOOL_ID primary key (ID);
  
  
 -- Create sequence 
create sequence SEQ_PL_STD_RECORD_SCHOOL
minvalue 1
start with 1
increment by 1;