test

Tables (9)

Address

  • address_id — BIGINT(20) — Primary key — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • modify_date — TIMESTAMP — NOT NULL
  • member_id — BIGINT(20) — Foreign key → Members.member_id — NOT NULL

Carts

  • cart_id — BIGINT(20) — Primary key — NOT NULL
  • quantity — INT(11) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • item_id — BIGINT(20) — Foreign key → items.item_id — NOT NULL
  • member_id — BIGINT(20) — Foreign key → Members.member_id — NOT NULL
  • brand_id — BIGINT(20) — Foreign key → brand.brand_id — NOT NULL

Dibs

  • dib_id — BIGINT(20) — Primary key — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • modify_date — TIMESTAMP — NOT NULL
  • member_id — BIGINT(20) — Foreign key → Members.member_id — NOT NULL
  • item_id — BIGINT(20) — Foreign key → items.item_id — NOT NULL

Members

  • member_id — BIGINT(20) — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • grade — VARCHAR(100) — NOT NULL
  • role — VARCHAR(100) — NOT NULL
  • current_address — VARCHAR(100)
  • create_date — TIMESTAMP — NOT NULL
  • modify_date — TIMESTAMP — NOT NULL

Orders

  • order_id — BIGINT(20) — Primary key — NOT NULL
  • payment_method — VARCHAR(255) — NOT NULL
  • total_price — INT(15) — NOT NULL
  • delivery_request — VARCHAR(255)
  • create_date — TIMESTAMP — NOT NULL
  • modify_date — TIMESTAMP — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • brand_id — BIGINT(20) — Foreign key → brand.brand_id — NOT NULL
  • member_id — BIGINT(20) — Foreign key → Members.member_id — NOT NULL

Qna

  • qna_id — BIGINT(20) — Primary key — NOT NULL
  • category — VARCHAR(20) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • item_id — BIGINT(20) — Foreign key → items.item_id — NOT NULL
  • member_id — BIGINT(20) — Foreign key → Members.member_id — NOT NULL

Reviews

  • review_id — BIGINT(20) — Primary key — NOT NULL
  • rating — INT(1) — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • create_date — TIMESTAMP — NOT NULL
  • modify_date — TIMESTAMP — NOT NULL
  • item_id — BIGINT(20) — Foreign key → items.item_id — NOT NULL
  • member_id — BIGINT(20) — Foreign key → Members.member_id — NOT NULL

brand

  • brand_id — BIGINT(20) — Primary key — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • brand_picture_url — TEXT
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL

items

  • item_id — BIGINT(20) — Primary key — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • item_picture_url — TEXT
  • content — VARCHAR(255) — NOT NULL
  • rating — DECIMAL(3,1) — NOT NULL
  • review_count — INT(11) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • modified_date — TIMESTAMP — NOT NULL
  • quantity — INT(20) — NOT NULL
  • brand_id — BIGINT(20) — Foreign key → brand.brand_id — NOT NULL