TOYPLEPRO
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
- COMMENT_ID — int — Primary key
- USER_ID — int — Foreign key → USER.USER_ID — NOT NULL
- PROJECT_ID — varchar(100) — Foreign key → PROJECT.PROJECT_ID — NOT NULL
- 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_ID (USER_ID2) — int — Foreign key → USER.USER_ID — NOT NULL
- STATUS
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)