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)