coffeeapplication
Tables (10)
coffee (커피)
- coffee_id (PK) — Primary key — NOT NULL
- price (Field)
- kor_name (Field2)
- eng_name (Field3)
- coffee_status (Field4)
comment (댓글)
- comment_id (PK) — Primary key — NOT NULL
- post_id (FK1) — Foreign key → post.post_id — NOT NULL
- member_id (FK2) — Foreign key → post.member_id — NOT NULL
- comment (Field)
- created_at (Field3)
- modified_at (Field2)
- comment_status (Field4)
deliveryorder (배달주문)
- deliveryorder_id (PK) — Primary key — NOT NULL
- order_id (FK1) — Foreign key → order.order_id — NOT NULL
- member_id (FK2) — Foreign key → order.member_id — NOT NULL
- created_ad (Field1)
- complite_ad (Field2)
favorite (최애커피)
- favorite_id (PK) — Primary key — NOT NULL
- member_id (FK1) — Foreign key → member.member_id — NOT NULL
- coffee_id (FK2) — Foreign key → coffee.coffee_id — NOT NULL
- count (Field3)
member (회원)
- member_id (PK) — Primary key — NOT NULL
- email (Field)
- password (Field2)
- name (Field3)
- phone (Field4)
order (주문)
- order_id (PK) — Primary key — NOT NULL
- member_id (FK) — Foreign key → member.member_id — NOT NULL
- created_ad (Field)
- modified_ad (Field2)
- order_status (Field3)
ordercoffee (커피주문)
- ordercoffee_id (PK) — Primary key — NOT NULL
- order_id (FK1) — Foreign key → order.order_id — NOT NULL
- coffee_id (FK2) — Foreign key → coffee.coffee_id — NOT NULL
- member_id (PK2) — Foreign key → order.member_id — NOT NULL
- quantity (Field3)
post (게시판)
- post_id (PK) — Primary key — NOT NULL
- member_id (PK2) — Foreign key → member.member_id — NOT NULL
- title (Field)
- created_at (Field2)
- modified_at (Field3)
- content (Field4)
- post_status (Field5)
role (Untitled)
- Key — Primary key — NOT NULL
- role_name (Field)
- role_description (Field2)
- created_at (Field3)
- modified_at (Field4)
stamp (쿠폰)
- stamp_id (PK) — Primary key — NOT NULL
- member_id (FK1) — Foreign key → member.member_id — NOT NULL
- stamp_count (Field)
- created_ad (Field2)
- expration_ad (Field3)