test
Tables (14)
brands
- brand_id — BIGINT
- name — VARCHAR(255) — NOT NULL
categories
- category_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- parent_id — BIGINT
funding_details
- funding_detail_id — BIGINT
- funding_id — BIGINT
- member_id — BIGINT
- amount — DECIMAL(10, 2) — NOT NULL
- is_paid — BOOLEAN
fundings
- funding_id — BIGINT
- product_id — BIGINT
- funding_period — DATE
gifts
- gift_id — BIGINT
- product_id — BIGINT
- order_date — DATE — NOT NULL
- expiry_date — DATE — NOT NULL
- exchange_place — VARCHAR(255)
- coupon_status — VARCHAR(50)
- order_amount — DECIMAL(10, 2) — NOT NULL
hashtags
- hashtag_id — BIGINT
- name — VARCHAR(255) — NOT NULL
members
- member_id — BIGINT
- name — VARCHAR(255) — NOT NULL
option_details
- option_detail_id — BIGINT
- option_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- stock_quantity — INT — NOT NULL
options
- option_id — BIGINT
- product_id — BIGINT
- name — VARCHAR(255) — NOT NULL
orders
- order_id — BIGINT
- product_id — BIGINT
- order_date — DATE — NOT NULL
- quantity — INT — NOT NULL
- is_available — BOOLEAN
payments
- payment_id — BIGINT
- member_id — BIGINT
- payment_date — TIMESTAMP — NOT NULL
- payment_target — VARCHAR(255)
- payment_type — VARCHAR(50)
product_hashtags
- product_id — BIGINT
- hashtag_id — BIGINT
products
- product_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- quantity — INT — NOT NULL
- brand_id — BIGINT
- category_id — BIGINT
- theme — VARCHAR(255)
wishes
- wish_id — BIGINT
- product_id — BIGINT
- member_id — BIGINT
- is_public — BOOLEAN