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