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