공문/공지/동의문
테이블 (10)
ros_notice
- notice_id — int8 — 기본 키 — NOT NULL
- author_type — varchar(50) — NOT NULL
- document_type — varchar(50) — NOT NULL
- target_type — varchar(50) — NOT NULL
- published_yn — varchar(1) — NOT NULL
- popup_yn — varchar(1) — NOT NULL
- popup_start_date — timestamp
- popup_end_date — timestamp
- title — varchar(255) — NOT NULL
- content — text
- status — varchar(50) — NOT NULL
- urgent_yn — varchar(1) — NOT NULL
- inquiry_yn — varchar(1) — NOT NULL
- publication_start_date — timestamp
- publication_end_date — timestamp
- create_user_id — varchar(255)
- create_date — timestamp — NOT NULL
- update_user_id — varchar(255)
- update_date — timestamp — NOT NULL
- delete_date — timestamp
ros_notice_agreement (동의문)
- notice_agreement_id — int8 — 기본 키 — NOT NULL
- notice_id (notice_id2) — int8 — 외래 키 → ros_notice.notice_id — NOT NULL
- notice_id — bigint — NOT NULL
- response_target_count — integer
- achievement_status — varchar(50)
- reuse_deadline — timestamp
ros_notice_agreement_response (동의문 응답 이력)
- notice_agreement_response_id — int8 — 기본 키 — NOT NULL
- notice_agreement_id — int8 — 외래 키 → ros_notice_agreement.notice_agreement_id — NOT NULL
- notice_id (notice_id2) — int8 — 외래 키 → ros_notice_agreement.notice_id — NOT NULL
- est_cd — varchar(100) — NOT NULL
- response — varchar(50) — NOT NULL
- response_date — timestamp — NOT NULL
ros_notice_attachment (첨부파일)
- notice_attachment_id — int8 — 기본 키 — NOT NULL
- notice_id (notice_id2) — int8 — 외래 키 → ros_notice.notice_id — NOT NULL
- file_name — varchar(255) — NOT NULL
- file_path — text — NOT NULL
- file_size_bytes — bigint
- file_type — varchar(50)
- create_user_id — varchar(255)
- create_date — timestamp — NOT NULL
ros_notice_inquiry (1:1 문의)
- notice_inquiry_id — int8 — 기본 키 — NOT NULL
- notice_id (notice_id2) — int8 — 외래 키 → ros_notice.notice_id — NOT NULL
- est_cd — varchar(100) — NOT NULL
- question — text — NOT NULL
- create_date — timestamp — NOT NULL
ros_notice_inquiry_reply (1:1 문의 답변)
- notice_inquiry_reply_id — int8 — 기본 키 — NOT NULL
- notice_inquiry_id (notice_inquiry_id2) — int8 — 외래 키 → ros_notice_inquiry.notice_inquiry_id — NOT NULL
- notice_id (notice_id2) — int8 — 외래 키 → ros_notice_inquiry.notice_id — NOT NULL
- notice_inquiry_id — bigint — NOT NULL
- reply — text — NOT NULL
- create_user_id — varchar(255)
- create_date — timestamp — NOT NULL
- update_user_id — varchar(255)
- update_date — timestamp — NOT NULL
ros_notice_notification (알림 공지)
- notice_notification_id — int8 — 기본 키 — NOT NULL
- notice_id (notice_id2) — int8 — 외래 키 → ros_notice.notice_id — NOT NULL
- notification_type — varchar(50) — NOT NULL
- enabled_yn — varchar(1) — NOT NULL
- send_count — integer — NOT NULL
ros_notice_official_document
- notice_official_document_id — int8 — 기본 키 — NOT NULL
- notice_id (notice_id2) — int8 — 외래 키 → ros_notice.notice_id — NOT NULL
- notice_id — bigint — NOT NULL
- reference — varchar(100)
- greeting_message — text
- confirmation_checkbox_yn — varchar(1) — NOT NULL
ros_notice_sample_phrase (샘플 문구)
- notice_sample_phrase_id — int8 — 기본 키 — NOT NULL
- category — varchar(255) — NOT NULL
- content — text — NOT NULL
- create_user_id — varchar(255)
- create_date — timestamp — NOT NULL
- update_user_id — varchar(255)
- update_date — timestamp — NOT NULL
ros_notice_target (공지 대상)
- notice_target_id — int8 — 기본 키 — NOT NULL
- notice_id (notice_id2) — int8 — 외래 키 → ros_notice.notice_id — NOT NULL
- est_cd — varchar(100) — NOT NULL
- viewed_yn — varchar(1) — NOT NULL
- view_date — timestamp