thirdparty_policy

Tables (4)

Untitled (thirdparty_policy_version)

  • Key (id) — Primary key — NOT NULL
  • Key (thirdparty_policy_id) — int — Foreign key → thirdparty_policy.Key — NOT NULL
  • Field (date) — date
  • Field2 (number) — int
  • Field (is_latest) — boolean — NOT NULL
  • Field2 (file_path) — varchar(200) — s3 file path
  • Field
  • Field2

Untitled (openlaw)

  • Key (id) — Primary key — NOT NULL
  • Field (is_active) — boolean — NOT NULL
  • Field2 (name) — varchar(512)
  • Field3 (last_updated) — datetime
  • Field4

Untitled (openlaw_version)

  • Key (id) — int — Primary key — NOT NULL
  • Key (openlaw_id) — Foreign key → Untitled.Key — NOT NULL
  • Field2 (promulgation_date) — datetime — NOT NULL — 공포일자
  • Field3 (enforcement_date) — datetime — 시행일자
  • Field4 (is_latest) — boolean — NOT NULL
  • Field (pdf_filepath) — varchar(512) — pdf 파일 경로
  • Field5 (amendment_content) — text — 개정문내용
  • Field (amendment_reason) — text — 제개정이유내용
  • Field

thirdparty_policy

  • Key — int — Primary key — NOT NULL
  • Field (name) — varchar(200) — 이름/제목
  • Field (url) — varchar(500) — NOT NULL — 타사 문서 url
  • Field2 (user_id) — int — null: 기본문서
  • Field (is_default) — boolean — NOT NULL
  • Field (is_active) — boolean — NOT NULL — ai 기능에 해당 데이터 반영 여부
  • Field (latest_version_date) — date
  • Field3 (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL
  • Field2 (deleted_at)