asdf
Tables (4)
Applicants (지원서)
- id (고유키) — bigint — Primary key — NOT NULL
Term (동의서)
- id (고유키) — bigint — Primary key — NOT NULL
- workspace_id (워크스페이스 ID) — bigint
- type (동의서 타입) — varchar
- is_require (필수/선택 여부) — bit
- is_active (활성화 여부) — bit
- created_at (생성일) — datetime
- updated_at (수정일) — datetime
TermAgree (동의여부)
- id (고유키) — bigint — Primary key — NOT NULL
- applicant_id (지원자 id) — bigint — Foreign key → Applicants.id — NOT NULL
- term_id (동의서 id) — bigint — Foreign key → Term.id — NOT NULL
- agreement_items (보훈 동의 여부) — text(json)
- type (동의한 동의서 타입) — varchar
- is_agree (동의여부) — bit
- created_at (생성일) — datetime
- updated_at (수정일) — datetime
Term_Content (동의서 번역)
- locale(PK) (언어) — varchar — Primary key — NOT NULL
- term_id(PK) (동의서 id) — bigint — Foreign key → Term.id — NOT NULL
- title (제목) — varchar
- content (내용) — varchar
- created_at (생성일) — datetime
- updated_at (수정일) — datetime