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