coinDB

테이블 (8)

게시글좋아요 (좋아요)

  • Board ID (board_id) — INT(15) — 외래 키 → 노래방정보게시판.Board ID — NOT NULL
  • User ID (user_id) — VARCHAR(15)

노래방DB

  • SR ID (sr_id) — INT(15) — 기본 키 — NOT NULL
  • SR Location (sr_location) — VARCHAR(255)
  • SR Price (sr_price) — VARCHAR(15)
  • SR Star (sr_star) — VARCHAR(15)
  • SR item1 (sr_item1) — INT(1)
  • SR item2 (sr_item2) — INT(1)
  • SR item3 (sr_item3) — INT(1)
  • SR item4 (sr_item4) — INT(1)
  • SR item5 (sr_item5) — INT(1)
  • SR item6 (sr_item6) — INT(1)
  • SR item7 (sr_item7) — INT(1)
  • SR Name (sr_name) — VARCHAR(15)

노래방리뷰

  • SR ID (sr_id) — INT(15) — 외래 키 → 노래방DB.SR ID — NOT NULL
  • Reviewer ID (reviewer_id) — VARCHAR(15)
  • Review Star (review_star) — VARCHAR(15)
  • Review Content (review_content) — VARCHAR(255)

노래방정보게시판 (게시판)

  • Board ID (board_id) — INT(15) — 기본 키 — NOT NULL
  • SR ID (sr_id) — INT(15) — 외래 키 → 노래방DB.SR ID — NOT NULL
  • Board Writer (board_writer) — VARCHAR(15)
  • Board Title (board_title) — VARCHAR(15)
  • Board Content (board_content) — VARCHAR(255)
  • Board Hit (board_hit) — INT(10)
  • Board Good (board_good) — INT(10)
  • Board Date (board_date) — VARCHAR(30)
  • Board Ref (board_ref) — INT(10)

댓글

  • Board ID (board_id) — INT(15) — 외래 키 → 노래방정보게시판.Board ID — NOT NULL
  • Comment Wirter (comment_writer) — VARCHAR(15)
  • ref — INT(10)
  • Comment comtent (comment_content) — VARCHAR(255)

파일 (자료실)

  • File ID (file_id) — INT(15) — 기본 키 — NOT NULL
  • File Name (file_name) — VARCHAR(15)
  • File Location (file_location) — VARCHAR(255)
  • File Uploader (file_uploader) — VARCHAR(15)

회원

  • User ID (user_id) — VARCHAR(15) — 기본 키 — NOT NULL
  • User PW (user_pw) — VARCHAR(15)
  • User Name (user_name) — VARCHAR(15)
  • User Address (user_address) — VARCHAR(255)
  • User Phone (user_phone) — VARCHAR(15)
  • User Email (user_email) — VARCHAR(15)
  • User Gender (user_gender) — VARCHAR(15)

회원리뷰

  • User ID (user_id) — VARCHAR(15) — 외래 키 → 회원.User ID — NOT NULL
  • Reviewer ID (reviewer_id) — VARCHAR(15)
  • Review Star (review_star) — VARCHAR(15)
  • Review Content (review_content) — VARCHAR(255)