You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.
数据表创建的步骤：
1、使用Naicat Premium 创建物理模型，
2、转换物理模型为Postgresql 9.6版本。
3、导出Sql,用Notepad++打开，
4、将索引index字样的删除掉.
5、在gp加中执行建表语句，
--- ###########################################################################
全量
-- 年级表
select * from t_dm_grade;
-- 学段表
select * from t_dm_stage;
-- 科目表
select * from t_dm_subject;
--- ###########################################################################
增量
-- 教师表
select * from t_base_person limit 1;
-- 学生表
select * from t_base_student limit 1;
-- 家长表
select * from t_base_parent limit 1;
-- 单位与部门
select * from t_base_organization limit 1;
-- 一个人员在多个部门
select * from t_base_org_person;
-- 班级表
select * from t_base_class;
-- =================================================
-- 资源表
select * from t_resource_base;
select * from t_resource_info;
select * from t_resource_scheme;
select * from t_resource_structure;
select * from t_wkds_base;
select * from t_wkds_info;
select * from t_zy_info;
select * from t_zy_paper;
select * from t_zy_topic;
--- ###########################################################################
