Community
대략적인 ERD 추후 수정가능
테이블 (8)
Admin (관리자)
- admin — 기본 키 — NOT NULL
- admin (r_del)
- admin (r_hide)
Image (이미지)
- image (Field)
- image (Field2) — 외래 키 → Image admin.image — NOT NULL
Image admin (관리자 이미지)
- image (Field) — 기본 키 — NOT NULL
Notice (공지사항)
- notice_no (n_no) — INT
- notice_title (n_title) — VARCHAR
- notice_writer (n_writer) — VARCHAR
- notice_date (n_date) — DATE
- notice_check (n_check) — INT
- notice_del
Q&A (문의하기)
- qna_no (q_no) — INT
- qna_title (q_title) — VARCHAR
- qna_admin (q_admin)
- qna_admin (Key) — 외래 키 → Q&A admin.qna_admin — NOT NULL
Q&A admin (Q&A 관리자)
- qna_admin (Key) — 기본 키 — NOT NULL
- qna_writer (q_writer)
Review (이용후기)
- review_no (r_no) — INT
- review_title (r_title) — VARCHAR
- review_writer (r_writer) — VARCHAR
- review_date (r_date) — DATE
- review_check (r_check) — INT
- reservation_check (Key) — 외래 키 → Review Check.reservation_check — NOT NULL
- admin
- admin (admin2) — 외래 키 → Admin.admin — NOT NULL
Review Check (예약자 확인)
- reservation_check (Key) — 기본 키 — NOT NULL
- Reservation_name (name) — VARCHAR
- reservation_no — VARCHAR
- reservation_over