공지사항

테이블 (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