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