teat1
Tables (15)
Untitled (APPLICANT)
- Key (ANUM) — number — Primary key — NOT NULL
- Field (addressnum) — varchar2
- Field (address) — varchar2
- Field (marry) — varchar2
- Field (call) — varchar2
- Field (jumin) — number
- Field (kname) — varchar2
- Field (Cname) — varchar2
- Field (Registdate) — date
Untitled (certificate)
- Key (Ccode) — varchar2 — Primary key — NOT NULL
- Field (Cname) — varchar2
Untitled (certificate own)
- Key (ANUM) — number — Foreign key → Untitled.Key — NOT NULL
- Key (Ccode) — varchar2 — Foreign key → Untitled.Key — NOT NULL
- Field (owndate) — date
Untitled (language)
- Field (lcode) — varchar2 — Primary key
- Field (lname) — varchar2
Untitled (language use)
- Key (ANUM) — number — Foreign key → Untitled.Key — NOT NULL
- Field (lcode) — varchar2 — Foreign key → Untitled.Field
- Field (lgrade) — varchar2
Untitled (Work Performance)
- Key (WPnum) — number — Primary key — NOT NULL
- Key (CORDER2) — NUMBER — Foreign key → Untitled.Key — NOT NULL
- Key (ANUM) — number — Foreign key → Untitled.Key — NOT NULL
- Field (WPperiod) — varchar2
- Field (WPContents) — varchar2
Untitled (Career)
- Key (CORDER) — NUMBER — Primary key — NOT NULL
- Key (ANUM) — number — Foreign key → Untitled.Key — NOT NULL
- Field (CPOSTION) — VARCHAR2
- Field (CWPLACE) — VARCHAR2
- Field (WORK) — VARCHAR2
- Field (SAL) — NUMBER
- Field (RETIRE REASON) — VARCHAR2
- Field (END DATE) — DATE
- Field (START DATE\) — DATE
Untitled (FAMILY)
- Key (FNUM) — NUMBER — Primary key — NOT NULL
- Key (ANUM) — number — Foreign key → Untitled.Key — NOT NULL
- Field (RELATE) — VARCHAR2
- Field (NAME) — VARCHAR2
- Field (JOB) — VARCHAR2
- Field (WPLACE) — VARCHAR2
- Field (POSITION) — VARCHAR2
Untitled (ETC EDU)
- Key (ETCENUM) — NUMBER — Primary key — NOT NULL
- Key (ANUM) — number — Foreign key → Untitled.Key — NOT NULL
- Field (EDUFACILITIES) — VARCHAR2
- Field (EDUCONTENT) — VARCHAR2
- Field (EDUPERIOD) — VARCHAR2
Untitled (EDUCATION)
- Key (EDUCATIONCODE) — VARCHAR2 — Primary key — NOT NULL
- Field (EDUCATIONNAME) — VARCHAR2
Untitled (MAJOR)
- Key (MCODE) — VARCHAR2 — Primary key — NOT NULL
- Field (MAJOR) — VARCHAR2
Untitled (EDUCATIONCONTENTS)
- Key (MCODE) — VARCHAR2 — Foreign key → Untitled.Key — NOT NULL
- Key (ANUM) — number — Foreign key → Untitled.Key — NOT NULL
- Key — NOT NULL
- Key (EDUCATIONCODE) — VARCHAR2 — Foreign key → Untitled.Key — NOT NULL
Untitled (APPLICANT INFO)
- Key (ANUM) — number — Foreign key → Untitled.Key — NOT NULL
- Field (BTYPE) — VARCHAR2
- Field (HEIGHT) — NUMBER
- Field (WEIGHT) — NUMBER
- Field (LEYESIGHT) — NUMBER
- Field (REYESIGHT) — NUMBER
- Field (RELIGION) — VARCHAR2
- Field (SPECIALNOTE) — VARCHAR2
- Field (HOBBY) — VARCHAR2
- Field
Untitled (TESTREGION)
- Key (ANUM) — number — Foreign key → Untitled.Key — NOT NULL
- Field (1REGION) — VARCHAR2 — Foreign key → Untitled.Field
- Field (2REGION) — VARCHAR2 — Foreign key → Untitled.Field
Untitled (REGION)
- Field (REGIONCODE) — VARCHAR2 — Primary key
- Field (REGION) — VARCHAR2