짹짹

테이블 (8)

Company (company)

  • companyPK (company_id) — Long — 기본 키 — NOT NULL
  • company_name — varchar(255) — NOT NULL

Member (member)

  • memberPK (member_id) — Long — 기본 키 — NOT NULL — pk
  • username (Field) — varchar(255) — NOT NULL
  • password (Field2) — varchar(255) — NOT NULL
  • nickname (Field3) — varchar(255) — NOT NULL

Resume (resume)

  • resumePK (resume_id) — Long — 기본 키 — NOT NULL
  • memberFK (member_id) — Long — 외래 키 → Member.memberPK — NOT NULL — pk
  • company_job_PK (Key) — 외래 키 → company_job.Key — NOT NULL

ResumeContent

  • resume_content_PK (resume_content_id) — Long — 기본 키 — NOT NULL
  • resumePK (resume_id) — Long — 외래 키 → Resume.resumePK — NOT NULL
  • question_type_PK (question3) — Long — 외래 키 → questionType.question — NOT NULL
  • question (question2) — TEXT — NOT NULL
  • answer — TEXT — NOT NULL

company_job (Untitled)

  • Key — Long — 기본 키 — NOT NULL
  • jobPK (job_id) — Long — 외래 키 → job.jobPK — NOT NULL
  • companyPK (company_id) — Long — 외래 키 → Company.companyPK — NOT NULL

job

  • jobPK (job_id) — Long — 기본 키 — NOT NULL
  • job_name — varchar(255) — NOT NULL

questionType (question)

  • question — Long — 기본 키 — NOT NULL
  • company_job_PK (Key) — Long — 외래 키 → company_job.Key — NOT NULL
  • question_TYPE — varchar(255) — NOT NULL

statistic

  • statisticPK (statistic_id) — Long — 기본 키 — NOT NULL
  • question_typePK (question) — Long — 외래 키 → questionType.question — NOT NULL
  • subject — varchar(255) — NOT NULL
  • value — varchar(255) — NOT NULL