TWINGKLING
Tables (13)
address_detail
- address_detail_id — BIGINT — Primary key — NOT NULL
- address_main — VARCHAR
- address_detail — VARCHAR
- zip_number — BIGINT
- deleted_yn — BOOLEAN
cart
- cart_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- quantity — BIGINT
- present_sale_yn — BOOLEAN
- deleted_yn — BOOLEAN
category
- category_id — BIGINT — Primary key — NOT NULL
- upper_category_id — BIGINT
- category_name — VARCHAR
like
- like_id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- deleted_yn — BOOLEAN
member
- member_id — BIGINT — Primary key — NOT NULL
- role_id — BIGINT — Foreign key → role.role_id — NOT NULL
- email — VARCHAR
- password — VARCHAR
- created_at — DATETIME
- deleted_yn — BOOLEAN
member_address
- member_address_id — BIGINT — Primary key — NOT NULL
- address_detail_id — BIGINT — Foreign key → address_detail.address_detail_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- is_primary — BOOLEAN
- used_at — DATETIME
member_detail
- member_detail_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- name — VARCHAR
- nickname — VARCHAR
- phone_number — VARCHAR
- age — VARCHAR
- gender — VARCHAR
- birth — DATE
order
- order_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- address_detail_id — BIGINT — Foreign key → address_detail.address_detail_id — NOT NULL
- receive_name — VARCHAR
- phone_number — VARCHAR
- payment_date — DATETIME
- deliver_date — DATETIME
- create_at — DATETIME
- deleted_yn — BOOLEAN
- order_state — VARCHAR
- total_price — BIGINT
- deliver_Fee — BIGINT
- pay_id — BIGINT — Foreign key → pay.pay_id — NOT NULL
order_detail
- order_detail_id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → order.order_id — NOT NULL
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- quantity — BIGINT
- deleted_yn — BOOLEAN
- price — BIGINT
pay
- pay_id — BIGINT — Primary key — NOT NULL
- 결제 타입 (pay_type) — VARCHAR
- 결제처 (pay_social) — VARCHAR
product
- product_id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Foreign key → category.category_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- product_name — VARCHAR
- register_quantity (Field6) — BIGINT
- sale_quantity — BIGINT
- created_at — DATETIME
- delete_yn — BOOLEAN
- price — BIGINT
- product_state — VARCHAR
review
- review_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- content — VARCHAR
- socre — BIGINT
- deleted_yn — BOOLEAN
role
- role_id — BIGINT — Primary key — NOT NULL
- role_name — VARCHAR