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