servlet&jsp
Tables (10)
ADDRESS (지역)
- ID (Key) — NUMBER — Primary key — NOT NULL
- DISTRICT (Field) — VARCHAR2
ARTICLE (구인글)
- ID (Key) — NUMBER — Primary key — NOT NULL
- COMPANY_ID (Key2) — NUMBER — Foreign key → COMPANY.ID — NOT NULL
- ADDRESS_ID (Key3) — NUMBER — Foreign key → ADDRESS.ID — NOT NULL
- TITLE (Field) — VARCHAR2
- CAREER (Field2) — VARCHAR2
- SALARY (Field3) — NUMBER
- DETAIL_ADDR (Field4) — VARCHAR2
- NEED_AMT (Field5) — NUMBER
- JOB_EXPLAIN (Field6) — VARCHAR2
- DEADLINE (Field7) — DATE
- QUALIFY (Field8) — VARCHAR2
COMPANY (회사)
- ID (Key) — NUMBER — Primary key — NOT NULL
- C_SCALE_ID (Key3) — NUMBER — Foreign key → C_SCALE.ID — NOT NULL
- ADDRESS_ID (Key2) — NUMBER — Foreign key → ADDRESS.ID — NOT NULL
- COMPANY_NO (Field) — VARCHAR2
- PASSWORD (Field2) — VARCHAR2
- ESTA (Field3) — DATE
- EMPLOYEE_NO (Field4) — NUMBER
- CEO (Field5) — VARCHAR2
- URL (Field6) — VARCHAR2
- DETAIL_ADDR (Field7) — VARCHAR2
- CONTENT (Field8) — VARCHAR2
C_SCALE (회사 규모)
- ID (Key) — NUMBER — Primary key — NOT NULL
- TITLE (Field) — VARCHAR2
GENDER (성별)
- ID (Key) — NUMBER — Primary key — NOT NULL
- TITLE (Field) — VARCHAR2
JOB (Untitled)
- ID (Key) — NUMBER — Primary key — NOT NULL
- ARTICLE_ID (Key2) — NUMBER — Foreign key → ARTICLE.ID — NOT NULL
- ID (Key3) — NUMBER — Foreign key → ARTICLE.ADDRESS_ID — NOT NULL
- NAME (Field) — VARCHAR2
MEMBER (구직자)
- ID (Key) — NUMBER — Primary key — NOT NULL
- ADDRESS_ID (Key2) — NUMBER — Foreign key → ADDRESS.ID — NOT NULL
- GENDER_ID (Key3) — NUMBER — Foreign key → GENDER.ID — NOT NULL
- USER_ID (Field) — VARCHAR2
- PASSWORD (Field2) — VARCHAR2
- NAME (Field3) — VARCHAR2
- BIRTHDAY (Field4) — DATE
- PHONE (Field5) — VARCHAR2
- EMAIL (Field6) — VARCHAR2
- DETAIL_ADDR (Field7) — VARCHAR2
RESUME (이력서)
- ID (Key) — NUMBER — Primary key — NOT NULL
- MEMBER_ID (Key2) — NUMBER — Foreign key → MEMBER.ID — NOT NULL
- TITLE (Field) — VARCHAR2
- PORTFOLIO (Field2) — VARCHAR2
- SELF_INTRO (Field3) — VARCHAR2
SEND (CopyOfCopyOfUntitled)
- ID (Key) — NUMBER — Primary key — NOT NULL
- ARTICLE_ID (Key2) — NUMBER — Foreign key → ARTICLE.ID — NOT NULL
- RESUME_ID (Key3) — NUMBER — Foreign key → RESUME.ID — NOT NULL
- CONSENT (Field) — DATE
SKILL_STACK (CopyOfUntitled)
- ID (Key) — NUMBER — Primary key — NOT NULL
- ARTICLE_ID (Key2) — NUMBER — Foreign key → ARTICLE.ID — NOT NULL
- NAME (Field) — VARCHAR2