asdf
Tables (9)
address
- address_id — BIGINT
- member_id — BIGINT — NOT NULL
- recipient_name — VARCHAR(100) — NOT NULL
- recipient_phone — VARCHAR(50) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- detail_address — VARCHAR(255)
- zip_code — VARCHAR(30) — NOT NULL
- is_default — BOOLEAN
- create_at — DATETIME
- update_at — DATETIME
category
- category_id — BIGINT
- parent_category_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- create_at — DATETIME
- update_at — DATETIME
kakao_payment
- kakao_payment_id — BIGINT
- tid — VARCHAR(200) — NOT NULL
- partner_order_id — VARCHAR(100) — NOT NULL
- partner_user_id — VARCHAR(100) — NOT NULL
- status — VARCHAR(30)
- total_amount — INT
- tax_free_amount — INT
- payment_method_type — VARCHAR(50)
- created_at — DATETIME
- approved_at — DATETIME
- canceled_at — DATETIME
member
- member_id — BIGINT
- sns_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(150) — NOT NULL
- nick_name — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(50) — NOT NULL
- role — VARCHAR(30) — NOT NULL
- login_type — VARCHAR(30) — NOT NULL
- create_at — DATETIME
- update_at — DATETIME
order_item
- order_item_id — BIGINT
- order_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- quantity — INT
- order_price — INT
- create_at — DATETIME
- update_at — DATETIME
orders
- order_id — BIGINT
- member_id — BIGINT — NOT NULL
- address_id — BIGINT — NOT NULL
- kakao_payment_id — BIGINT
- order_status — VARCHAR(30) — NOT NULL
- tracking_number — VARCHAR(100)
- order_cancel_at — DATETIME
- create_at — DATETIME
- update_at — DATETIME
product
- product_id — BIGINT
- category_id — BIGINT — NOT NULL
- name — VARCHAR(150) — NOT NULL
- description — TEXT
- price — INT — NOT NULL
- count — INT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- create_at — DATETIME
- update_at — DATETIME
product_images
- product_image_id — BIGINT
- product_id — BIGINT — NOT NULL
- image_url — VARCHAR(255)
- create_at — DATETIME
- update_at — DATETIME
refresh_token
- refresh_token_id — BIGINT
- member_id — BIGINT — NOT NULL
- refresh_token — VARCHAR(600) — NOT NULL
- expired_at — DATETIME