SnackForYou_db

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 → users.user_id

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

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 → users.user_id

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 → cart.cart_id

favorites

  • favorite_id — serial — Primary key
  • created_at — timestamp
  • user_id — serial — Foreign key → users.user_id
  • snack_id — serial — Foreign key → snack_info.snack_id

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 → users.user_id
  • address_id — serial — Foreign key → address.address_id

order_items

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

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 → users.user_id
  • snack_id — serial — Foreign key → snack_info.snack_id
  • order_item_id (order_item_id2) — serial — Foreign key → order_items.order_item_id

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 → snack_category.category_id

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