방탈출카페 통합 서비스 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