방탈출카페 통합 서비스 ERD
테이블 (17)
attendance (Untitled2)
- id — BIGINT AUTOINCREMENT — 기본 키 — NOT NULL
- findboard_id — BIGINT — 외래 키 → findBoard.findboard_id — NOT NULL — AUTO_INCREMENT , PIRMARY KEY
- member_id — BIGINT — 외래 키 → member.member_id
- email — VARCHAR
- delyn — VARCHAR
- chatroom_id — BIGINT — 외래 키 → chatroom.id — NOT NULL
board
- board_id — INT — 기본 키 — NOT NULL
- member_id — INT — 외래 키 → member.member_id
- writer — VARCHAR(50)
- title — VARCHAR(100)
- content — TEXT
- board_hits — INT
- likes — INT
- dislikes — INT
- createdTime (created_at) — DATETIME
- updateTime (update_at) — DATETIME
- image — BLOB
- notification_state — TINYINT
- board_type — ENUM("FREE","STRATEGY") — NOT NULL — not null
- del_yn — VARCHAR(1) DEFALUT "Y"
board_image (Untitled5)
- id — BIGINT — 기본 키 — NOT NULL
- board_id — BIGINT — 외래 키 → board.board_id — NOT NULL
- imageurl — VARCHAR
- delyn — VARCCHAR
chat_message (Untitled3)
- id (Key) — Long — 기본 키 — NOT NULL
- sender (Field) — String
- timestamp (Field2) — Long
- content (Field3) — Stirng
- room_id (rroom_id) — Long — 외래 키 → chat_room.room_id — NOT NULL
chat_room (채팅방)
- room_id (rroom_id) — Long — 기본 키 — NOT NULL
- member_id — INT — 외래 키 → member.member_id
- name — String
chatroom (Untitled4)
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR
- password — VARCHAR
comment (comments)
- comment_id — INT — 기본 키
- board_id — INT — 외래 키 → board.board_id — NOT NULL
- member_id — VARCHAR(255)
- content — VARCHAR(255)
- likes — INT
- dislikes — INT
- createdTime (created_at) — DATETIME
- updateTime (updated_at) — DATETIME
- del_yn — ENUM('N', 'Y')
- notification_state — TINYINT
findBoard (Untitled)
- findboard_id — INT — 기본 키 — NOT NULL — AUTO_INCREMENT , PIRMARY KEY
- member_id — INT — 외래 키 → member.member_id
- title — VARCHAR(255)
- contents — VARCHAR(3000)
- createdTime (created_at) — DATETIME — DEFAULT CURRENT_TIMESTAMP
- updatedTime (updated_at) — DATETIME — DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
- expiration_date — DATETIME
- current_count — INT — DEFAULT 0
- total_capacity — TINYINT
- participant_count — INT — DEFAULT 2 최소 2명은 되게끔
- image — BLOB
- del_yn — VARCHAR(1) DEFALUT "Y"
- writer (wirter) — VARCHAR(15) not null
game
- game_id — INT — 기본 키 — NOT NULL
- store_id (id2) — INT — 외래 키 → store_info.store_id — NOT NULL
- review_id — INT — 외래 키 → review.review_id
- difficulty — ENUM(1,2,3,4,5)
- running_time — VARCHAR(255)
- game_rating — DECIMAL(3,2)
- price — VARCHAR(255)
- game_name — VARCHAR(100)
- maximum_person — INT — 수용 인원
- game_info — TEXT
- game_image — BLOB
- age — ENUM(''19세 미만,'19세이상')
- likes — INT
grade
- grade_id — INT — 기본 키 — NOT NULL
- grade_name — VARCHAR(10)
- member_id — INT — 외래 키 → member.member_id
likes (wishlist)
- likes_id — INT — 기본 키 — NOT NULL
- game_id — INT — 외래 키 → game.game_id — NOT NULL
- member_id — INT — 외래 키 → member.member_id
member
- member_id — INT — 기본 키
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- profile_img — BLOB
- point — INT
- age — TINYINT
- role — enum("USER","OWNER")
- phone_number — VARCCHAR(255)
- nickname — VARCHAR(100)
- createdTime (created_At) — DATETIME
- updateTime (updated_At) — DATETIME
- del_yn — ENUM('N', 'Y')
notification
- id — INT — 기본 키 — NOT NULL
- store_id — INT
- sender_email — VARCHAR(255)
- email — VARCHAR(255)
- notification_type — ENUM
- message (messgae) — VARCHAR(255)
- ApprovalStatus — ENUM
- del_yn — ENUM('N', 'Y')
- Field3
owner
- owner_id — Long — 기본 키
- username — VARCHAR(50
- password — VARCHAR(255)
- store_name — VARCHAR(50)
- email — VARCHAR(255)
- role — enum("회원","점주")
reservation (Reservation)
- reservation_id — INT — 기본 키
- member_id — INT — 외래 키 → member.member_id
- game_id — INT — 외래 키 → game.game_id — NOT NULL
- reservation_date — DATE
- reservation_time — TIME
- count_people — INT — 사람 수
- created_at — DATETIME
- state — ENUM('ACCEPT','WAITING', 'REJECT')
- notification_state — TINYINT
- Field
- store_id (id2) — INT — 외래 키 → store_info.store_id — NOT NULL
- createdTime (Field2)
review (Review)
- review_id — INT — 기본 키
- member_id — INT — 외래 키 → member.member_id
- reservation_id — INT — 외래 키 → reservation.reservation_id
- contents — TEXT
- rating — INT
- img — BLOB
- createdTime (created_at) — DATETIME
- updateTime (updated_at) — DATETIME
- del_yn — ENUM('N', 'Y')
store_info (store)
- store_id (id) — INT — 기본 키 — NOT NULL
- store_name — VARCHAR(100) — NOT NULL
- store_rating — DECIMAL(3,2)
- opening_hours — VARCHAR(100) — NOT NULL
- open_status — ENUM('영업중','영업 종료','휴무') — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- info — TEXT
- owner_id — Long — 외래 키 → owner.owner_id