wanted
Tables (4)
COMPANY (회사)
- Key (COMPANY_ID) — BIGINT — Primary key — NOT NULL
- 이름 (NAME) — varchar(32)
- Field
RECRUIT (지원)
- Key (RECRUIT_ID) — BIGINT — Primary key — NOT NULL
- Key (USER_ID) — BIGINT — Foreign key → USER.Key — NOT NULL
- Key (COMPANY_ID) — BIGINT — Foreign key → COMPANY.Key — NOT NULL
- Field
RECURIT_ANNOUNCEMENT (채용공고)
- Key (POST_ID) — BIGINT — Primary key — NOT NULL
- Key (COMPANY_ID) — BIGINT — Foreign key → COMPANY.Key — NOT NULL
- 채용 포지션 (RECRUIT_POSITION) — varchar(32)
- 채용 지역 (WORKING_AREA) — varchar(32)
- 채용보상금 (RECURITY_REWORD) — INT
- 사용기술 (SKILL) — varchar(32)
- 등록일자 (CREATE_DATE) — DATETIME
- 수정일자 (MODIFIED_DATE) — DATETIME
- Field
USER (사용자)
- Key (USER_ID) — BIGINT — Primary key — NOT NULL
- 이름 (NAME) — varchar(32)
- 비밀번호 (PASSWORD) — varchar(32)
- 이메일 (EMAIL) — varchar(20)
- 등록일자 (CREATE_DATE) — DATETIME
- 수정일자 (MODIFIED_DATE) — DATETIME