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)