공지사항
테이블 (10)
agreement_details (동의서)
- aggrement_id (document_id) — bigint — 기본 키
- document_id (id2) — bigserial — 외래 키 → notice.document_id
- response_target_count — integer
- achievement_status — varchar(50)
- reuse_deadline — timestamptz
agreement_responses (동의서 응답)
- aggrement_response_id (document_id) — bigint — 기본 키 — NOT NULL
- store_id — bigint — 기본 키 — NOT NULL
- aggrement_id (document_id2) — bigint — 외래 키 → agreement_details.aggrement_id
- document_id (id22) — bigserial — 외래 키 → agreement_details.document_id
- response — varchar(50) — NOT NULL
- responded_at — timestamptz — NOT NULL
attachments (첨부파일)
- attachment_id (id) — bigserial — 기본 키
- document_id (id2) — bigserial — 외래 키 → notice.document_id
- file_name — varchar(255) — NOT NULL
- file_path — text — NOT NULL
- file_size_bytes — bigint
- file_type — varchar(50)
- created_at — timestamptz — NOT NULL
document_targets (공개 대상)
- document_target_id (document_id) — bigint — 기본 키 — NOT NULL
- store_id — bigint — 기본 키 — NOT NULL
- document_id (id2) — bigserial — 외래 키 → notice.document_id
- is_viewed (Field)
- viewed_at (Field2)
document_views (문서 조회 기록)
- document_id — bigint — 기본 키 — NOT NULL
- store_id — bigint — 기본 키 — NOT NULL
- viewed_at — timestamptz — NOT NULL
inquiries (1:1 문의)
- inquirey_id (id) — bigserial — 기본 키
- document_id (id2) — bigserial — 외래 키 → notice.document_id
- store_id — bigint — NOT NULL
- question — text — NOT NULL
- created_at — timestamptz — NOT NULL
inquiry_replies (1:1 문의 답변)
- inquiry_id — bigint — 기본 키
- inquirey_id (id2) — bigserial — 외래 키 → inquiries.inquirey_id
- author_id — bigint — NOT NULL
- reply — text — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
notice (공지사항 - 공통)
- document_id (id) — bigserial — 기본 키
- author_id — bigint — NOT NULL
- author_type — varchar(50) — NOT NULL
- document_type — varchar(50) — NOT NULL
- title — varchar(255) — NOT NULL
- content — text
- status — varchar(50) — NOT NULL
- is_urgent — boolean — NOT NULL
- allow_inquiries — boolean — NOT NULL
- publication_start_date — timestamptz
- publication_end_date — timestamptz
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
- deleted_at — timestamptz
notifications (문서별 알림 설정)
- notification_id (id) — bigserial — 기본 키
- document_id (id2) — bigserial — 외래 키 → notice.document_id
- notification_type — varchar(50) — NOT NULL
- is_enabled — boolean — NOT NULL
- popup_start_date — date
- popup_end_date — date
official_document_details (공문)
- official_id (Key) — 기본 키 — NOT NULL
- document_id (id2) — bigserial — 외래 키 → notice.document_id
- reference — varchar(100)
- greeting_message — text
- has_confirmation_checkbox — boolean