ㅋㅋㅋ

Tables (5)

Applicants (지원서)

  • ID (고유키) — bigint — Primary key — NOT NULL
  • 기타 데이터 (Field)

OpeningTermList (공고별 동의서 순서)

  • ID (고유키) — bigint — Primary key — NOT NULL
  • term_order (Field5) — int
  • opening_id (Field1) — bigint — Foreign key → Openings.ID — NOT NULL
  • term_id (Field0) — bigint — Foreign key → Term.ID — NOT NULL

Openings (공고)

  • ID (고유키) — bigint — Primary key — NOT NULL
  • 기타 데이터 (Field)

Term (동의서)

  • ID (고유키) — bigint — Primary key — NOT NULL
  • workspace_id (Field) — bigint
  • title (Field2) — varchar
  • content (Field4) — text
  • is_require (Field6) — bit
  • locale (Field8) — varchar
  • term_type (Field9) — varchar
  • scope_type (Field3) — varchar

TermAgree (동의여부)

  • ID (고유키) — bigint — Primary key — NOT NULL
  • expired_at (Field2) — datetime
  • term_id (Field) — bigint — Foreign key → Term.ID — NOT NULL
  • applicant_id (Field1) — bigint — Foreign key → Applicants.ID — NOT NULL