ClickNBuy-ERD

ClickNBuy의 ERD 입니다.

테이블 (16)

account_payment

  • payment_method_id — INT — 외래 키 → payment_method.payment_method_id — NOT NULL
  • account_number — VARCHAR(20) — NOT NULL
  • bank_name — VARCHAR(50) — NOT NULL
  • is_deleted — Boolean — NOT NULL

address

  • address_id — INT — 기본 키 — NOT NULL
  • member_id — INT — 외래 키 → member.member_id — NOT NULL
  • addresss_nickname — VARCHAR(100)
  • recipient_name — VARCHAR(30)
  • recipient_phone — VARCHAR(30)
  • default_status — Boolean — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • created_at — DATE
  • updated_at — DATE
  • is_deleted — Boolean — NOT NULL

card_payment

  • payment_method_id — INT — 외래 키 → payment_method.payment_method_id — NOT NULL
  • card_number — VARCHAR(16) — NOT NULL
  • card_company_name — VARCHAR(20) — NOT NULL
  • is_deleted — Boolean — NOT NULL

cart

  • cart_id — 기본 키 — NOT NULL
  • member_id — INT — 외래 키 → member.member_id — NOT NULL
  • customer_id — INT — 외래 키 → customer.customer_id — NOT NULL
  • created_at — DATE
  • updated_at — DATE

cart_product

  • cart_product_id — INT — 기본 키 — NOT NULL
  • cart_id — INT — 외래 키 → cart.cart_id — NOT NULL
  • product_id — INT — 외래 키 → product.product_id — NOT NULL
  • order_option — VARCHAR(50) — NOT NULL
  • quantity — INT
  • created_at — DATE
  • updated_at — DATE

category

  • category_id — INT — 기본 키 — NOT NULL
  • category_name — VARCHAR(30) — NOT NULL
  • created_at — DATE
  • updated_at — DATE

customer

  • customer_id — INT — 기본 키 — NOT NULL
  • user_role — VARCHAR(20) — NOT NULL
  • customer_login_id — VARCHAR(100) — NOT NULL
  • customer_password — VARCHAR(60) — NOT NULL
  • customer_name — VARCHAR(100) — NOT NULL
  • customer_phone — VARCHAR(50) — NOT NULL
  • customer_email — VARCHAR(100) — NOT NULL
  • business_registration_number — VARCHAR(100) — NOT NULL
  • business_name — VARCHAR(50) — NOT NULL
  • business_owner — VARCHAR(50) — NOT NULL
  • business_open_date — DATE — NOT NULL
  • business_address — VARCHAR(100) — NOT NULL
  • description — VARCHAR(200) — NOT NULL
  • logo_image_original_name — VARCHAR(500)
  • logo_image_path — VARCHAR(700)
  • announcement — VARCHAR(2000)
  • fcm_token — DATE
  • created_at — DATE — NOT NULL
  • updated_at — DATE — NOT NULL

member

  • member_id — INT — 기본 키 — NOT NULL
  • user_role — VARCHAR(20) — NOT NULL
  • member_login_id — VARCHAR(100) — NOT NULL
  • member_password — VARCHAR(60) — NOT NULL
  • member_name — VARCHAR(100) — NOT NULL
  • member_email — VARCHAR(100) — NOT NULL
  • member_phone — VARCHAR(50) — NOT NULL
  • payment_password — VARCHAR(10) — NOT NULL
  • fcm_token — VARCHAR(100) — NOT NULL
  • created_at — DATE
  • updated_at — DATE

member_customer

  • member_customer_id — INT — 기본 키 — NOT NULL
  • member_id — INT — 외래 키 → member.member_id — NOT NULL
  • customer_id — INT — 외래 키 → customer.customer_id — NOT NULL
  • created_at — DATE
  • updated_at — DATE

order

  • order_id — INT — 기본 키 — NOT NULL
  • member_id — INT — 외래 키 → member.member_id — NOT NULL
  • payment_method_id — INT — 외래 키 → payment_method.payment_method_id — NOT NULL
  • address_id — INT — 외래 키 → address.address_id — NOT NULL
  • cart_id (Key) — INT — 외래 키 → cart.cart_id — NOT NULL
  • order_status — VARCHAR(50) — NOT NULL
  • created_at — DATE
  • updated_at — DATE

order_product

  • order_product_id — INT — 기본 키 — NOT NULL
  • order_id — INT — 외래 키 → order.order_id — NOT NULL
  • product_id — INT — 외래 키 → product.product_id — NOT NULL
  • quantity — INT — NOT NULL
  • price — INT — NOT NULL
  • discount — INT
  • order_product_status — VARCHAR(50) — NOT NULL

payment_method

  • payment_method_id — INT — 기본 키 — NOT NULL
  • member_id — INT — 외래 키 → member.member_id — NOT NULL
  • payment_type — VARCHAR(30) — NOT NULL
  • payment_nickname — VARCHAR(20)
  • created_at — DATE
  • updated_at — DATE
  • is_deleted — Boolean — NOT NULL

pending_member

  • pending_member_id — INT — 기본 키 — NOT NULL
  • customer_id — INT — 외래 키 → customer.customer_id — NOT NULL
  • pending_member_name — VARCHAR(100) — NOT NULL
  • pending_member_email — VARCHAR(100) — NOT NULL
  • pending_member_phone — VARCHAR(50) — NOT NULL

product

  • product_id — INT — 기본 키 — NOT NULL
  • customer_id — INT — 외래 키 → customer.customer_id — NOT NULL
  • category_id — INT — 외래 키 → category.category_id — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • product_description — VARCHAR(255) — NOT NULL
  • product_price — INT — NOT NULL
  • product_discount — INT
  • product_status — Boolean — NOT NULL
  • order_option — VARCHAR(50) — NOT NULL
  • product_image_original_name — VARCHAR(255)
  • product_image_path — VARCHAR(255)
  • stock_quantity — INT — NOT NULL
  • created_at — DATE
  • updated_at — DATE
  • is_deleted — Boolean — NOT NULL

subscription_order

  • subscription_order_id — INT — 기본 키 — NOT NULL
  • member_id — INT — 외래 키 → member.member_id — NOT NULL
  • payment_method_id — INT — 외래 키 → payment_method.payment_method_id — NOT NULL
  • address_id — INT — 외래 키 → address.address_id — NOT NULL
  • interval_days — INT — NOT NULL
  • order_status — VARCHAR(50) — NOT NULL
  • next_order_date — DATE
  • created_at — DATE
  • updated_at — DATE

subscription_order_product

  • subscription_order_product_id — INT — 기본 키 — NOT NULL
  • subscription_order_id — INT — 외래 키 → subscription_order.subscription_order_id — NOT NULL
  • product_id (product_id2) — INT — 외래 키 → product.product_id — NOT NULL
  • cycle_number — INT — NOT NULL
  • price — INT — NOT NULL
  • quantity — INT — NOT NULL
  • order_product_status — VARCHAR(50) — NOT NULL
  • discount — INT
  • created_at — DATE — NOT NULL
  • updated_at — DATE