DBA_Portfolio

Tables (8)

Category (카테고리)

  • category_id (카테고리번호) — BIGINT — Primary key — NOT NULL
  • category_name (카테고리명) — VARCHAR(50)

Delivery (배송)

  • delievery_id (배송번호) — BIGINT — Primary key — NOT NULL
  • order_id (주문번호) — BIGINT — Foreign key → Orders.order_id — NOT NULL
  • recipient_name (수령인) — VARCHAR(50)
  • recipient_phone (연락처) — VARCHAR(20)
  • address (주소) — VARCHAR(255)
  • delivery_status (배송상태) — VARCHAR(20)
  • shipped_at (출고일) — DATETIME
  • delivered_at (배송완료일) — DATETIME

Member (회원)

  • member_id (회원번호) — BIGINT — Primary key — NOT NULL
  • email (이메일) — VARCHAR(100)
  • password (비밀번호) — VARCHAR(255)
  • member_name (이름) — VARCHAR(50)
  • phone (전화번호) — VARCHAR(20)
  • created_at (가입일) — DATETIME
  • updated_at (수정일) — DATETIME

OrderItem (주문상세)

  • order_item_id (주문상품번호) — BIGINT — Primary key — NOT NULL
  • order_id (주문번호) — BIGINT — Foreign key → Orders.order_id — NOT NULL
  • product_id (상품번호) — BIGINT — Foreign key → Product.product_id — NOT NULL
  • quantity (주문수량) — INT
  • order_price (주문당시가격) — INT

Orders (주문)

  • order_id (주문번호) — BIGINT — Primary key — NOT NULL
  • member_id (회원번호) — BIGINT — Foreign key → Member.member_id — NOT NULL
  • order_date (주문날짜) — DATETIME
  • total_price (총 주문금액) — INT
  • order_status (주문상태) — VARCHAR(20)

Payment (결제)

  • payment_id (결제번호) — BIGINT — Primary key — NOT NULL
  • order_id (주문번호) — BIGINT — Foreign key → Orders.order_id — NOT NULL
  • payment_method (결제수단) — VARCHAR(20)
  • payment_amount (결제금액) — INT
  • payment_status (결제상태) — VARCHAR(20)
  • payment_date (결제일시) — DATETIME

Product (상품)

  • product_id (상품번호) — BIGINT — Primary key — NOT NULL
  • category_id (카테고리번호) — BIGINT — Foreign key → Category.category_id — NOT NULL
  • product_name (상품명) — VARCHAR(50)
  • price (가격) — INT
  • stock (재고) — INT
  • created_at (등록일) — DATETIME
  • updated_at (수정일) — DATETIME
  • description (설명) — TEXT

Review (리뷰)

  • review_id (리뷰번호) — BIGINT — Primary key — NOT NULL
  • member_id (회원번호) — BIGINT — Foreign key → Member.member_id — NOT NULL
  • order_item_id (주문상품번호) — BIGINT — Foreign key → OrderItem.order_item_id — NOT NULL
  • rating (평점) — INT
  • content (리뷰내용) — TEXT
  • created_at (작성일) — DATETIME