coffee app

Tables (10)

board (게시글)

  • board_id (PK) — bigint — Primary key — NOT NULL
  • member_id (FK) — bigint — Foreign key → member.member_id — NOT NULL
  • title (제목) — varcher
  • content (내용) — text
  • board_status (게시글상태) — enum
  • created_at (생성일) — datetime
  • last_modified_at (수정일) — datetime
  • view_count (조회수) — int
  • like_count (좋아요수) — int

coffee (커피)

  • coffee_id (PK) — bigint — Primary key — NOT NULL
  • korName (한글명) — varchar
  • engName (영어명) — varchar
  • category (카테고리) — varchar
  • price (가격) — int
  • coffee_code (커피코드) — varchar(3)
  • coffee_status (커피상태) — varchar
  • explanation (설명) — text
  • created_at (생성일) — timestamp
  • modified_at (수정일) — timestamp

comment (댓글)

  • comment_id (PK) — bigint — Primary key — NOT NULL
  • board_id (FK1) — bigint — Foreign key → board.board_id — NOT NULL
  • member_id (FK2) — bigint — Foreign key → member.member_id — NOT NULL
  • content (내용) — text
  • visiblity_status (공개여부) — varchar
  • created_at (생성일) — datetime
  • last_modified_at (수정일) — datetime

like (좋아요)

  • like_id (PK) — bigint — Primary key — NOT NULL
  • member_id (FK1) — bigint — Foreign key → member.member_id — NOT NULL
  • board_id (FK2) — bigint — Foreign key → board.board_id — NOT NULL

member (회원)

  • member_id (PK) — bigint — Primary key — NOT NULL
  • email (이메일) — varchar
  • name (이름) — varchar
  • password (비밀번호) — int
  • phone (전화번호) — int
  • member_status (회원상태) — varchar
  • created_at (생성일) — datetime

order (주문)

  • order_id (PK) — bigint — Primary key — NOT NULL
  • member_id (FK) — bigint — Foreign key → member.member_id — NOT NULL
  • order_status (주문상태) — varchar
  • created_at (생성일) — datetime

orderCoffee (주문커피)

  • orderCoffee_id (PK) — bigint — Primary key — NOT NULL
  • order_id (FK1) — int — Foreign key → order.order_id — NOT NULL
  • coffee_id (FK2) — int — Foreign key → coffee.coffee_id — NOT NULL
  • quantity (수량) — int

role (권한)

  • role_id (PK) — bigint — Primary key — NOT NULL
  • member_id (FK) — bigint — Foreign key → member.member_id — NOT NULL
  • name (Field) — varchar

stamp (스탬프)

  • stamp_id (PK) — bigint — Primary key — NOT NULL
  • member_id (PK2) — bigint — Foreign key → member.member_id — NOT NULL
  • count (갯수) — int
  • created_at (생성일) — datetime

view (조회)

  • view_id (PK) — bigint — Primary key — NOT NULL
  • member_id (FK2) — bigint — Foreign key → member.member_id — NOT NULL
  • board_id (FK1) — bigint — Foreign key → board.board_id — NOT NULL