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