数据库技术，mysql，oracle

CREATE TABLE t_school_rank(
  id number(36) primary key not  null ,
  rank number(4) NOT NULL,
  myorder number(4) NOT NULL,
  name varchar2(600) NOT NULL,
  overall varchar2(20),
  stu_rate varchar2(20),
  teach_rate varchar2(20),
  ratio varchar2(20),
  link varchar2(2000),
  listname varchar2(120) NOT NULL
  );
-- 添加表注释
COMMENT ON table t_school_rank IS '世界大学排名';
-- 添加字段注释
comment on column t_school_rank.rank is '排名';
comment on column t_school_rank.myorder is '自定义排序';
comment on column t_school_rank.name is '院校名称';
comment on column t_school_rank.overall is 'Overall';
comment on column t_school_rank.stu_rate is '国际学生占比';
comment on column t_school_rank.teach_rate is '国际教师比例';
comment on column t_school_rank.ratio is '师生比';
comment on column t_school_rank.link is '链接';
comment on column t_school_rank.listname is '榜单名称';