Text to Model
Tables (50)
Agency
- AgencyID — CHAR(20) — Primary key — NOT NULL
- AgencyName — VARCHAR2(100) — NOT NULL
Career
- CarID — CHAR(20) — Primary key — NOT NULL
- CarType — VARCHAR2(50) — NOT NULL
Cert
- CertID — CHAR(20) — Primary key — NOT NULL
- CertName — VARCHAR2(100) — NOT NULL
- CertTypeID — CHAR(20)
- AgencyID — CHAR(20)
- CertEligibility — VARCHAR2(2000) — NOT NULL
- CertFee — VARCHAR2(50) — NOT NULL
- CertValidity — VARCHAR2(50)
- CertApplyURL — VARCHAR2(2000) — NOT NULL
CertType
- CertTypeID — CHAR(20) — Primary key — NOT NULL
- CertTypeName — VARCHAR2(50) — NOT NULL
CityDist
- CityDistID — CHAR(20) — Primary key — NOT NULL
- CityDistName — VARCHAR2(50) — NOT NULL
Company
- CompID — CHAR(20) — Primary key — NOT NULL
- CompName — VARCHAR2(50) — NOT NULL
- IndID — CHAR(20)
- CompType — VARCHAR2(50) — NOT NULL
- CompCapital — VARCHAR2(50)
- CompRepresent — VARCHAR2(50) — NOT NULL
- CompInsurance — VARCHAR2(50)
- CompEmpCount — VARCHAR2(50)
- CompFoundDate — DATE — NOT NULL
- CompRevenue — VARCHAR2(50)
- CompBusiness — VARCHAR2(2000)
- CompURL — VARCHAR2(2000)
- RegID — CHAR(20)
Dept
- DeptID — CHAR(20) — Primary key — NOT NULL
- DeptName — VARCHAR2(50) — NOT NULL
- DeptContact — VARCHAR2(20)
- DeptURL — VARCHAR2(2000)
DeptEdu
- EduDeptID — CHAR(20) — Primary key — NOT NULL
- DeptID — CHAR(20) — Foreign key → Dept.DeptID — NOT NULL
- EduID — CHAR(20) — Foreign key → Edu.EduID — NOT NULL
DeptEvent
- DeptEventID — CHAR(20) — Primary key — NOT NULL
- EventID — CHAR(20) — Foreign key → Event.EventID — NOT NULL
- DeptID — CHAR(20) — Foreign key → Dept.DeptID — NOT NULL
DeptNatProg
- DeptNatProgID — CHAR(20) — Primary key — NOT NULL
- DeptID — CHAR(20) — Foreign key → Dept.DeptID — NOT NULL
- NatProgID — CHAR(20) — Foreign key → NatProg.NatProgID — NOT NULL
Edu
- EduID — CHAR(20) — Primary key — NOT NULL
- EduName — VARCHAR2(100) — NOT NULL
- EduInstID — CHAR(20)
- TrainStart — DATE — NOT NULL
- EduAvgAge — VARCHAR2(20)
- TrainTypeID — CHAR(20)
- EduStatus — CHAR(1) — NOT NULL
- RegID — CHAR(20)
- NatProgID — CHAR(20)
- EduURL — VARCHAR2(2000)
- TrainEnd — DATE — NOT NULL
EduCert
- EduCertID — CHAR(20) — Primary key — NOT NULL
- EduID — CHAR(20) — Foreign key → Edu.EduID — NOT NULL
- CertID — CHAR(20) — Foreign key → Cert.CertID — NOT NULL
EduInst
- EduInstID — CHAR(20) — Primary key — NOT NULL
- EduInstName — VARCHAR2(50) — NOT NULL
- InstContactName — VARCHAR2(50)
- InstContactPhone — VARCHAR2(20)
- InstContactEmail — VARCHAR2(250)
- RegID — CHAR(20)
- EduInstURL — VARCHAR2(2000)
EduLevel
- EduLvlID — CHAR(20) — Primary key — NOT NULL
- EduLvlType — VARCHAR2(50) — NOT NULL
EduSKill
- EduSklID — CHAR(20) — Primary key — NOT NULL
- EduID — CHAR(20) — Foreign key → Edu.EduID — NOT NULL
- SklID — CHAR(20) — Foreign key → Skill.SklID — NOT NULL
Event
- EventID — CHAR(20) — Primary key — NOT NULL
- EventTypeID — CHAR(20)
- EventName — VARCHAR2(200) — NOT NULL
- EventStartDate — DATE — NOT NULL
- EventEndDate — DATE — NOT NULL
- RegID — CHAR(20)
- EventTarget — VARCHAR2(50) — NOT NULL
- EventDesc — VARCHAR2(2000) — NOT NULL
- EventRegURL — VARCHAR2(2000) — NOT NULL
- EventOperator — VARCHAR2(50) — NOT NULL
EventType
- EventTypeID — CHAR(20) — Primary key — NOT NULL
- EventName — VARCHAR2(50) — NOT NULL
- EventDesc — VARCHAR2(2000) — NOT NULL
ExamSched
- ExamSchedID — CHAR(20) — Primary key — NOT NULL
- CertID — CHAR(20)
- ExamRegStart — DATE — NOT NULL
- ExamExtraRegStart — DATE
- ExamStart — DATE — NOT NULL
- ExamResultDate — DATE — NOT NULL
- ExamRegEnd — DATE — NOT NULL
- ExamExtraRegEnd — DATE
- ExamEnd — DATE — NOT NULL
HostInst
- HostInstID — CHAR(20) — Primary key — NOT NULL
- HostInstName — VARCHAR2(50) — NOT NULL
- HostInstContact — VARCHAR2(50) — NOT NULL
- HostInstURL — VARCHAR2(2000) — NOT NULL
HostInstEvent
- HostEventID — CHAR(20) — Primary key — NOT NULL
- HostInstID — CHAR(20) — Foreign key → HostInst.HostInstID — NOT NULL
- EventID — CHAR(20) — Foreign key → Event.EventID — NOT NULL
Industry
- IndID — CHAR(20) — Primary key — NOT NULL
- IndDes — VARCHAR2(2000) — NOT NULL
- IndMajID — CHAR(20)
- IndMidID — CHAR(20)
IndustryMajor
- IndMajID — CHAR(20) — Primary key — NOT NULL
- IndMajName — VARCHAR2(50) — NOT NULL
IndustryMiddle
- IndMidID — CHAR(20) — Primary key — NOT NULL
- IndMidName — VARCHAR2(50) — NOT NULL
Job
- JobID — CHAR(20) — Primary key — NOT NULL
- JobSubID — CHAR(20)
- JobDesc — VARCHAR2(2000)
- JobMajID — CHAR(20)
- JobMidID — CHAR(20)
JobCert
- JobCertID — CHAR(20) — Primary key — NOT NULL
- JobID — CHAR(20) — Foreign key → Job.JobID — NOT NULL
- CertID — CHAR(20) — Foreign key → Cert.CertID — NOT NULL
JobEdu
- JobEduID — CHAR(20) — Primary key — NOT NULL
- EduID — CHAR(20) — Foreign key → Edu.EduID — NOT NULL
- JobIndID — CHAR(20)
JobIndEvent
- JobIndEventID — CHAR(20) — Primary key — NOT NULL
- JobIndID — CHAR(20) — Foreign key → JobIndustry.JobIndID — NOT NULL
- EventID — CHAR(20) — Foreign key → Event.EventID — NOT NULL
JobIndSkill
- JobSklID — CHAR(20) — Primary key — NOT NULL
- SklID — CHAR(20) — Foreign key → Skill.SklID — NOT NULL
- JobIndID — CHAR(20) — Foreign key → JobIndustry.JobIndID — NOT NULL
JobIndustry
- JobIndID — CHAR(20) — Primary key — NOT NULL
- JobID — CHAR(20) — Foreign key → Job.JobID — NOT NULL
- IndID — CHAR(20) — Foreign key → Industry.IndID — NOT NULL
JobMajor
- JobMajID — CHAR(20) — Primary key — NOT NULL
- JobMajName — VARCHAR2(50) — NOT NULL
- JobMajDesc — VARCHAR2(2000)
JobMiddle
- JobMidID — CHAR(20) — Primary key — NOT NULL
- JobMidName — VARCHAR2(50) — NOT NULL
- JobMidDesc — VARCHAR2(2000)
JobPost
- JobPostID — CHAR(20) — Primary key — NOT NULL
- RecruitPostID — CHAR(20) — Foreign key → RecruitPost.RecruitPostID — NOT NULL
- JobIndID — CHAR(20)
JobSub
- JobSubID — CHAR(20) — Primary key — NOT NULL
- JobSubName — VARCHAR2(50) — NOT NULL
- JobSubDesc — VARCHAR2(2000)
Major
- MajorID — CHAR(20) — Primary key — NOT NULL
- MajorName — VARCHAR2(50)
NatProg
- NatProgID — CHAR(20) — Primary key — NOT NULL
- NatProgName — VARCHAR2(50) — NOT NULL
- NatProgDesc — VARCHAR2(2000) — NOT NULL
- NatProgSupport — VARCHAR2(50) — NOT NULL
- NatProgApply — VARCHAR2(2000) — NOT NULL
- NatURL — VARCHAR2(2000) — NOT NULL
- NatProgStart — DATE — NOT NULL
- NatProgEnd — DATE — NOT NULL
- NatProgAmount — VARCHAR2(50) — NOT NULL
- NatProgActive — CHAR(1) — NOT NULL
- InsMinPeriod — INT — NOT NULL
- NatProgMinTargetAge — VARCHAR2(50) — NOT NULL
- RegID — CHAR(20)
- InsMaxPeriod — INT — NOT NULL
- NatProgMaxTargetAge — VARCHAR2(50) — NOT NULL
- NatProgTargetGender — VARCHAR2(12) — NOT NULL
PostCertReq
- PostCertID — CHAR(20) — Primary key — NOT NULL
- RecruitPostID — CHAR(20) — Foreign key → RecruitPost.RecruitPostID — NOT NULL
- CertID — CHAR(20) — Foreign key → Cert.CertID — NOT NULL
PostSkillReq
- PostSklID — CHAR(20) — Primary key — NOT NULL
- RecruitPostID — CHAR(20) — Foreign key → RecruitPost.RecruitPostID — NOT NULL
- JobSklID — CHAR(20) — Foreign key → JobIndSkill.JobSklID — NOT NULL
Province
- ProvID — CHAR(20) — Primary key — NOT NULL
- ProvName — VARCHAR2(50) — NOT NULL
RecruitPost
- RecruitPostID — CHAR(20) — Primary key — NOT NULL
- CompID — CHAR(20)
- PostTitle — VARCHAR2(250) — NOT NULL
- EduLvlID — CHAR(20)
- PostPref — VARCHAR2(200)
- PostEmpType — VARCHAR2(50) — NOT NULL
- PostSalary — VARCHAR2(50) — NOT NULL
- RegID — CHAR(20)
- RecruitStart — DATE — NOT NULL
- RecruitEnd — DATE — NOT NULL
- CarID — CHAR(20)
Region
- RegID — CHAR(20) — Primary key — NOT NULL
- ProvID — CHAR(20)
- CityDistID — CHAR(20)
School
- SchID — CHAR(20) — Primary key — NOT NULL
- SchName — VARCHAR2(50) — NOT NULL
- EduLvlID — CHAR(20) — Foreign key → EduLevel.EduLvlID — NOT NULL
Skill
- SklID — CHAR(20) — Primary key — NOT NULL
- SklName — VARCHAR2(50) — NOT NULL
- SklTypeID — CHAR(20) — Foreign key → SkillType.SklTypeID — NOT NULL
SkillType
- SklTypeID — CHAR(20) — Primary key — NOT NULL
- SklTypeName — VARCHAR2(50) — NOT NULL
TrainType
- TrainTypeID — CHAR(20) — Primary key — NOT NULL
- TrainTypeName — VARCHAR2(100) — NOT NULL
UserCareer
- UserCarID — CHAR(20) — Primary key — NOT NULL
- CompID — CHAR(20)
- JobID — CHAR(20)
- CarJoinDate — DATE — NOT NULL
- CarLeaveDate — DATE
- CarDesc — VARCHAR2(2000)
- UserID — CHAR(20)
UserCert
- UserCertID — CHAR(20) — Primary key — NOT NULL
- UserID — CHAR(20) — Foreign key → UserInfo.UserID — NOT NULL
- CertID — CHAR(20) — Foreign key → Cert.CertID — NOT NULL
- CertAcqDate — DATE — NOT NULL
UserEdu
- UserEduID — CHAR(20) — Primary key — NOT NULL
- UserID — CHAR(20) — Foreign key → UserInfo.UserID — NOT NULL
- EduID — CHAR(20) — Foreign key → Edu.EduID — NOT NULL
UserInfo
- UserID — CHAR(20) — Primary key — NOT NULL
- UserName — VARCHAR2(50) — NOT NULL
- UserGender — VARCHAR2(6) — NOT NULL
- UserBirth — DATE — NOT NULL
- EduLvlID — CHAR(20)
- SchID — CHAR(20)
- UserContact — VARCHAR2(30) — NOT NULL
- RegID — CHAR(20)
- UserJoinDate — DATE — NOT NULL
- LastInsurStartDate — DATE
- MajorID — CHAR(20) — Foreign key → Major.MajorID — NOT NULL
- UserLeaveDate — DATE
- LoginID — CHAR(20) — NOT NULL
- LoginPassword — CHAR(20) — NOT NULL
- LastInsurExpDate — DATE
UserJobPref
- UserJobPrefID — CHAR(20) — Primary key — NOT NULL
- UserID — CHAR(20) — Foreign key → UserInfo.UserID — NOT NULL
- JobIndID — CHAR(20)
UserRecProg
- UserRecProgID — CHAR(20) — Primary key — NOT NULL
- UserID — CHAR(20) — Foreign key → UserInfo.UserID — NOT NULL
- NatProgID — CHAR(20) — Foreign key → NatProg.NatProgID — NOT NULL
- RecDate — DATE — NOT NULL