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