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