-- Add/modify columns 
alter table KJ_UNIFIED_SCORE_DETAIL add cert_no VARCHAR2(18);
-- Add comments to the columns 
comment on column KJ_UNIFIED_SCORE_DETAIL.cert_no
  is '准考证';

-- Add/modify columns 
alter table KJ_COURSE_RATIO rename column apply_form to SCORE_TYPE;
-- Add comments to the columns 
comment on column KJ_COURSE_RATIO.score_type
  is '成绩类型(1-网络助学、2-专本衔接)';

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