server/ses-manage/sql/2020-04/2020-04-02.sql

CREATE TABLE "BY_CERTIFICATE" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"APP_ID" NUMBER, 
	"SCHOOL_ID" NUMBER, 
	"STD_ID" NUMBER, 
	"APPLY_DATE" DATE, 
	"STD_SOURCE" NUMBER, 
	"ORG_ID" NUMBER, 
	"STATUS" NUMBER, 
	"ORG_USERI_ID" NUMBER, 
	"ORG_AUTH_TIME" DATE, 
	"REMARK" VARCHAR2(255), 
	"BY_PHOTO" VARCHAR2(255), 
	 PRIMARY KEY ("ID")
   );
 CREATE SEQUENCE "SEQ_BY_CERTIFICATE"  MINVALUE 1  INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  ;
INSERT INTO "FRAME_RES"("RES_ID", "RES_NAME", "RES_ALIAS", "RES_URL", "RES_PID", "RES_LEVEL", "RES_TYPE", "RES_CSS", "RES_STATUS", "RES_ORDER", "RES_DESC") VALUES ('538', '毕业证明书', NULL, NULL, '6000', '2', 'Menu', NULL, 'Active', '34', NULL);
INSERT INTO "FRAME_RES"("RES_ID", "RES_NAME", "RES_ALIAS", "RES_URL", "RES_PID", "RES_LEVEL", "RES_TYPE", "RES_CSS", "RES_STATUS", "RES_ORDER", "RES_DESC") VALUES ('540', '毕业证明书审核', NULL, '/hmsoft/by/certificateaudit', '538', '3', 'Menu', NULL, 'Active', '1', NULL);
INSERT INTO "FRAME_RES"("RES_ID", "RES_NAME", "RES_ALIAS", "RES_URL", "RES_PID", "RES_LEVEL", "RES_TYPE", "RES_CSS", "RES_STATUS", "RES_ORDER", "RES_DESC") VALUES ('541', '毕业证明书查询', NULL, '/hmsoft/by/certificatequery', '538', '3', 'Menu', NULL, 'Active', '1', NULL);


INSERT INTO "FRAME_DICT_NAME"("DICT_NAME", "DICT_DESC", "MODIFY_FLAG", "FRAME_FLAG") VALUES ('ByCertificate', '毕业证明书', 'Active', 'Active');
INSERT INTO "FRAME_DICT"("DICT_NAME", "DICT_VALUE", "DICT_TEXT", "DICT_ORDER") VALUES ('ByCertificate', '1', '待受理审核', '1');
INSERT INTO "FRAME_DICT"("DICT_NAME", "DICT_VALUE", "DICT_TEXT", "DICT_ORDER") VALUES ('ByCertificate', '2', '待自考处审核', '2');
INSERT INTO "FRAME_DICT"("DICT_NAME", "DICT_VALUE", "DICT_TEXT", "DICT_ORDER") VALUES ('ByCertificate', '3', '审核通过', '3');
INSERT INTO "FRAME_DICT"("DICT_NAME", "DICT_VALUE", "DICT_TEXT", "DICT_ORDER") VALUES ('ByCertificate', '0', '审核不通过', '0');