짹짹
테이블 (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