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