SnackForYou_db - 2025-11-05 09:21:09

Tables (12)

address

  • address_id — serial — Primary key
  • name — varchar(20) — NOT NULL
  • road_name — varchar(200) — NOT NULL
  • detail_address — varchar(200) — NOT NULL
  • basic_address — boolean
  • request — text
  • created_at — timestamp
  • user_id (user_id2) — serial — Foreign key

admin

  • admin_id — serial — Primary key
  • id — varchar(30) — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(10) — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp
  • last_login — timestamp
  • role_id — serial — Foreign key

admin_role

  • role_id — serial — Primary key
  • role_name — varchar(5) — NOT NULL

cart

  • cart_id — SERIAL — Primary key
  • created_at — timestamp
  • user_id (user_id2) — serial — Foreign key

cart_items

  • cart_item_id — serial — Primary key
  • snack_id — int — NOT NULL
  • quantity — int — NOT NULL
  • price — int — NOT NULL
  • cart_id (cart_id2) — SERIAL — Foreign key

favorites

  • favorite_id — serial — Primary key
  • created_at — timestamp
  • user_id — serial — Foreign key
  • snack_id — serial — Foreign key

order_info

  • order_id — serial — Primary key
  • status — varchar(20) — NOT NULL
  • total_price — int — NOT NULL
  • payment_method — varchar(30) — NOT NULL
  • order_date — timestamp
  • user_id (user_id2) — serial — Foreign key
  • address_id — serial — Foreign key

order_items

  • order_item_id — serial — Primary key
  • quantity — int — NOT NULL
  • price — int — NOT NULL
  • order_id (order_id2) — serial — Foreign key
  • snack_id — serial — Foreign key

review

  • review_id — serial — Primary key
  • order_item_id — int — NOT NULL
  • content — text — NOT NULL
  • score — int — NOT NULL
  • wirted_at — timestamp
  • user_id — serial — Foreign key
  • snack_id — serial — Foreign key
  • order_item_id (order_item_id2) — serial — Foreign key

snack_category

  • category_id — serial — Primary key
  • name — varchar(10) — NOT NULL

snack_info

  • snack_id — serial — Primary key
  • name — varchar(100) — NOT NULL
  • brand — varchar(100) — NOT NULL
  • weight — varchar(100) — NOT NULL
  • composition — varchar(300) — NOT NULL
  • product_form — varchar(20) — NOT NULL
  • nation_info — varchar(200) — NOT NULL
  • price — int — NOT NULL
  • quantity — int — NOT NULL
  • product_image — varchar(1024) — NOT NULL
  • reg_at — timestamp
  • updated_at — timestamp
  • category_id — serial — Foreign key

users

  • user_id — serial — Primary key
  • name — varchar(20) — NOT NULL
  • nickname — varchar(25) — NOT NULL
  • id — varchar(30) — NOT NULL
  • password — varchar(255) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • last_login — timestamp