JOB

Tables (5)

COMMENT (댓글)

  • ID — VARCHAR2(50) — Primary key — NOT NULL
  • DATE — DATE
  • CONTENT — VARCHAR2(100)
  • COMPANY NAME — VARCHAR2(50)

COMPANY

  • NO — VARCHAR2(20) — Primary key — NOT NULL
  • ID — VARCHAR2(50) — Foreign key → COMMENT.ID — NOT NULL
  • START — DATE — Foreign key → JOB VACANCY.START — NOT NULL
  • NAME — VARCHAR2(50)
  • PW (pw) — VARCHAR2(50)
  • TEL — VARCHAR2(50)
  • ADDR — VARCHAR2(50)

JOB VACANCY (채용 공고)

  • START — DATE — Primary key — NOT NULL
  • END (ENDE) — DATE
  • COMPANY NAME — VARCHAR2(50)
  • ADMIT NUM — NUMBER
  • ADMIT DEPART — VARCHAR2(50)
  • LINE COMMENT — VARCHAR2(100)

MEMBER

  • ID — VARCHAR2(50) — Primary key — NOT NULL
  • ID (ID2) — VARCHAR2(50) — Foreign key → COMMENT.ID — NOT NULL
  • PW — VARCHAR2(50)
  • NAME — VARCHAR2(50)
  • TEL — VARCHAR2(50)
  • ADDR — VARCHAR2(50)
  • AUTHOR — VARCHAR2(10)

PASSINTRODUCTION (합격 자소서)

  • NO — VARCHAR2(20) — Foreign key → COMPANY.NO — NOT NULL
  • ID — VARCHAR2(50) — Foreign key → COMPANY.ID — NOT NULL
  • START — DATE — Foreign key → COMPANY.START — NOT NULL
  • ID (ID2) — VARCHAR2(50) — Foreign key → MEMBER.ID — NOT NULL
  • ID (ID22) — VARCHAR2(50) — Foreign key → MEMBER.ID — NOT NULL
  • COMPANY NAME — VARCHAR2(50)
  • NAME — VARCHAR2(50)
  • SEASON — VARCHAR2(50)
  • TITLE — VARCHAR2(50)
  • SUBJECT — VARCHAR2(50)
  • SPEC_A — VARCHAR2(50)
  • SPEC_B (SPEC_b) — VARCHAR2(50)
  • SPEC_C — VARCHAR2(50)
  • GRADE — NUMBER
  • UNIVERSITY — VARCHAR2(50)