TOYPLE_TEAM

Tables (9)

APPLICANT

  • USER_ID — varchar(100) — Foreign key → USER.USER_ID — NOT NULL
  • PROJECT_ID — varchar(100) — Foreign key → PROJECT.PROJECT_ID — NOT NULL
  • STATUS — varchar(100)

AREA

  • PROJECT_ID — varchar(100) — Foreign key → PROJECT.PROJECT_ID — NOT NULL
  • AREA — varchar2(100)
  • GU — varchar(100)

COMMNET

  • USER_ID — int — Foreign key → USER.USER_ID — NOT NULL
  • PROJECT_ID — varchar(100) — Foreign key → PROJECT.PROJECT_ID — NOT NULL
  • COMMENT_ID — int
  • CONTENT — VARCHAR(500)

JOB

  • PROJECT_ID — varchar(100) — Foreign key → PROJECT.PROJECT_ID — NOT NULL
  • 직무 — varchar(100)

LANGUAGE

  • PROJECT_ID — varchar(100) — Foreign key → PROJECT.PROJECT_ID — NOT NULL
  • Field — VARCHAR(255)

NOTICE

  • SENDER_ID — varchar(100) — Foreign key → USER.USER_ID — NOT NULL
  • RECEIVER_ID — varchar(100) — Foreign key → USER.USER_ID — NOT NULL
  • CONTENT — varchar(100)
  • REGDATE — datetime

PROJECT

  • PROJECT_ID — varchar(100) — Primary key — NOT NULL
  • PROJECT_NM — varchar(500)
  • CONTENT — varchar(1000)
  • DEADLINE — varchar(100)
  • COMMENT — varchar(100)
  • CLOSE_DT — varchar(100)
  • USER_ID2 — int — Foreign key → USER.USER_ID — NOT NULL
  • STATUS — VARCHAR(255)

REVIEW

  • SENDER_ID — varchar(100) — Foreign key → USER.USER_ID — NOT NULL
  • RECEIVER_ID — varchar(100) — Foreign key → USER.USER_ID — NOT NULL
  • PROJECT_ID — varchar(100) — Foreign key → PROJECT.PROJECT_ID — NOT NULL
  • CONTENT — varchar(1000)
  • STAR_WORK — double
  • STAR_COMMU — double
  • STAR_DILLIGENT — double

USER

  • USER_ID — varchar(100) — Primary key — NOT NULL
  • PASSWORD — varchar(300)
  • USER_NM — varchar(100) — NOT NULL
  • EMAIL — varchar(100)
  • INTRO — varchar(1000)
  • IMAGE — varchar(100)