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)