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