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)