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