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