shoppingmall
Tables (7)
cart
- id (Key) — bigint — Primary key — NOT NULL
- uid (Key2) — varchar — Foreign key → users.id — NOT NULL
- product_id (Key3) — bigint — Foreign key → product.id — NOT NULL
- option — varchar(255)
- quantity — integer
- created_at — timestamp
- created_by — varchar(255)
- modified_at — timestamp
- modified_by — varchar(255)
orders
- id (Key) — bigint — Primary key — NOT NULL
- uid (Key2) — bigint — Foreign key → users.id — NOT NULL
- order_token — varchar(255)
- order_status — varchar(255)
- payment_type — varchar(255)
- is_pay — boolean
- total_price — numeric(19, 2)
- total_quantity — integer
- delivery_fee — numeric(19, 2)
- promotion_discount — numeric(19, 2)
- receiver_name — varchar(255)
- receiver_tel — varchar(255)
- receiver_addr — varchar(255)
- receiver_addr_detail — varchar(255)
- receiver_email — varchar(255)
- delivery_msg — varchar(255)
- created_at — timestamp
- created_by — varchar(255)
- modified_at — timestamp
- modified_by — varchar(255)
orders_detail
- id (Key) — bigint — Primary key — NOT NULL
- orders_id (Key2) — bigint — Foreign key → orders.id — NOT NULL
- product_code — varchar(255)
- final_price — numeric(19, 2)
- origin_price — numeric(19, 2)
- quantity — integer
- discount — numeric(19, 2)
- product_name — varchar(255)
- option — integer
- created_at — timestamp
- created_by — varchar(255)
- modified_at — timestamp
- modified_by — varchar(255)
payment
- id (Key) — bigint — Primary key — NOT NULL
- orders_id (Key2) — bigint — Foreign key → orders.id — NOT NULL
- payment_type — varchar(255)
- pay_company_code — varchar(255)
- pay_amount — numeric(19, 2)
- card_company — varchar(255)
- card_no — varchar(255)
- card_exp_mon — varchar(255)
- card_exp_year — varchar(255)
- card_cvv — varchar(255)
- card_pw — varchar(255)
- created_at — timestamp
- created_by — varchar(255)
- modified_at — timestamp
- modified_by — varchar(255)
product
- id (Key) — bigint — Primary key — NOT NULL
- product_code — varchar(255)
- product_type — varchar(255)
- product_name — varchar(255)
- price — numeric(19, 2)
- thumbnail — varchar(255)
- detail_image — varchar(1000)
- service_type — varchar(255)
- option — varchar(255)
- is_delete — boolean
- created_at — timestamp
- created_by — varchar(255)
- modified_at — timestamp
- modified_by — varchar(255)
review
- id (Key) — bigint — Primary key — NOT NULL
- product_id (Key2) — bigint — Foreign key → product.id — NOT NULL
- users_id (Key3) — bigint — Foreign key → users.id — NOT NULL
- score — integer
- content — varchar(255)
- created_by — varchar(255)
- created_at — timestamp
- modified_at — timestamp
- modified_by — varchar(255)
users
- id (Key) — bigint — Primary key — NOT NULL
- uid — varchar(255)
- email — varchar(255)
- password — varchar(255)
- name — varchar(255)
- phone_number — varchar(255)
- authority — varchar(255)
- sign_up_type — varchar(255)
- user_type — varchar(255)
- point — integer
- created_at — timestamp
- created_by — varchar(255)
- modified_at — timestamp
- modified_by — varchar(255)