(NO.1
Mainly based on the fields given by the title, the database tables are generally organized. The title includes some corporate information, personnel information, and some basic information. According to the given fields and the relationship between each information, the table of the database is obtained as follows:
①tb_deptkind: part of the kind table
Include fields as follows:
column name data type length allow empty description
DkidInt4 no part kind number (primary key)
DkindVarchar250 No Partial species title
②tb_deptinfo: some detailed information
Include fields as follows:
column name data type length allow empty description
DeptnoInt4 no part number (primary key)
DnameVarchar50 No Partial Title
DkidInt4 no part kind number
③tb_duty: job information table
Include fields as follows:
column name data type length allow empty description
DutyidInt4 No job id (primary key)
DutynameVarchar20 no job title
DutygradeInt4 is a partial grade
HiredateVarchar10 is the appointment date
FiredateVarchar10 is the stop date
④tb_degree: Educational information table
Include fields as follows:
column name data type length allow empty description
IdInt4 no education number (primary key)
DegreeVarchar20 No Degree Title
⑤tb_nation: Nationality information table
Include fields as follows:
column name data type length allow empty description
IdInt4 no nationality number (primary key)
NationVarchar20 no national title
⑥tb_nativeplace: Origin information table
..........
Ouyang Ying's project\.metadata\.plugins\com.genuitec.org.hibernate.eclipse\hibernate-tools.log
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\0\00c3cb7fd3ac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\0\20c764d4a9ab001d1c64eff6fc784107
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\0\40e87d8c91ac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\0\70825e8ebdab001d1c64eff6fc784107
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\1\100dca1c2bab001d19d3cf3b8b331509
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\1\30178ae08fac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\1\70367d83ccac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\10\60d80ef4caab001d1c64eff6fc784107
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\10\80b371bebaac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\11\9006c9d8a4ac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\11\c03091d073aa001d1a45a5aecb698fca
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\11\f0d7c9f1aaab001d1c64eff6fc784107
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\13\a01f767a91ac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\13\e0a322cfa8ac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\14\00a0b43fd0ac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\14\a090209f39ab001d19d3cf3b8b331509
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\15\309d84128dac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\15\c03d24e7abac001d105fa91adc11449d
Ouyang Ying's project\.metadata\.plugins\org.eclipse.core.resources\.history\16\006ea06a38ab001d19d3cf3b8b331509
Ouyang Ying's Project\.m)