pop

Tables (13)

Cart (장바구니)

  • id (Key) — NUMBER — Primary key — NOT NULL
  • product_count (수량) — NUMBER — NOT NULL
  • product_id — NUMBER — Foreign key → Product_Option.id — NOT NULL
  • user_id — NUMBER — Foreign key → User.id — NOT NULL

Order (주문)

  • id (order_id) — NUMBER — Primary key — NOT NULL
  • receiver_name (받는 사람) — VARCHAR2(30) — NOT NULL
  • receiver_phone (받는 사람 연락처) — VARCHAR2(11) — NOT NULL
  • recipient_address (받는 사람 주소) — VARCHAR2(100) — NOT NULL
  • order_status (주문 상태) — VARCHAR2(10) — NOT NULL
  • created_at (주문 시점) — DATE — NOT NULL
  • delivered_at (배송 완료 시점) — DATE
  • user_id — NUMBER — Foreign key → User.id — NOT NULL

Order_Product (주문된 상품)

  • id (order_product_id) — NUMBER — Primary key — NOT NULL
  • count (주문 수량) — NUMBER — NOT NULL
  • price_each (상품가격 + 옵션가격(총 단가)) — NUMBER — NOT NULL — 주문 시점에 확정된 가격을 저장 (환불/정산을 위해서) 주문한 상품안에 상품번호/옵션 별로 저장해서 나중에 상품별로 환불이 가능함
  • order_id — NUMBER — Foreign key → Order.id — NOT NULL
  • product_option_id — NUMBER — Foreign key → Product_Option.id — NOT NULL
  • product_id — NUMBER — Foreign key → Product.id — NOT NULL

Payment (결제 기록)

  • id (payment_id) — NUMBER — Primary key — NOT NULL
  • total_price (전체금액) — NUMBER — NOT NULL
  • discount_price (할인금액) — NUMBER — NOT NULL
  • delivery_fee (배달금액) — NUMBER — NOT NULL
  • final_price (최종금액) — NUMBER — NOT NULL
  • created_at (생성일자) — DATE — NOT NULL
  • payment_type_id — NUMBER — Foreign key → Payment_Type.id — NOT NULL
  • order_id — NUMBER — Foreign key → Order.id — NOT NULL

Payment_Type (결제 타입)

  • id (payment_type_id) — NUMBER — Primary key — NOT NULL
  • name (타입 이름) — VARCHAR2(30) — NOT NULL

Product (상품)

  • id (Product) — NUMBER — Primary key — NOT NULL
  • name (상품 이름) — VARCHAR2(100) — NOT NULL
  • price (가격) — NUMBER — NOT NULL
  • type (종류) — VARCHAR2(20) — NOT NULL — ex)적포도 / 생과
  • variety (품종) — VARCHAR2(20) — NOT NULL — ex) 켐벨 / 샤인머스켓 / 흑체리
  • weight_gram (개당 중량) — NUMBER — NOT NULL
  • status (상품상태) — VARCHAR2(10) — NOT NULL
  • categori (카테고리) — VARCHAR2(20) — NOT NULL
  • image_url (이미지) — VARCHAR2(300) — NOT NULL

Product_Option (상품 옵션)

  • id (product_id) — NUMBER — Primary key — NOT NULL
  • name (상품옵션명) — VARCHAR2(256) — NOT NULL
  • option_price_diff (옵션 추가 금액) — NUMBER — NOT NULL
  • stock (재고) — NUMBER — NOT NULL
  • status (상품 상태) — ENUM — NOT NULL
  • created_at (생성일시) — DATE — NOT NULL
  • updated_at (수정일시) — DATE — NOT NULL
  • Product_id — NUMBER — Foreign key → Product.id — NOT NULL

Refund (환불 기록)

  • id (refund_id) — NUMBER — Primary key — NOT NULL
  • amount (총 환불금액) — NUMBER — NOT NULL
  • created_at (취소 시점) — DATE — NOT NULL
  • order_id — NUMBER — Foreign key → Order.id — NOT NULL

Refund_Order_Product (환불 상세 기록)

  • id (refund_order_product_id) — NUMBER — Primary key — NOT NULL
  • count (취소 수량) — NUMBER — NOT NULL
  • refund_id — NUMBER — Foreign key → Refund.id — NOT NULL
  • order_product_id — NUMBER — Foreign key → Order_Product.id — NOT NULL

Review (후기)

  • id (review_id) — NUMBER — Primary key — NOT NULL
  • title (제목) — VARCHAR2(100) — NOT NULL
  • description (상세내용) — VARCHAR2(500) — NOT NULL
  • created_at (생성일시) — DATE — NOT NULL
  • user_id — NUMBER — Foreign key → User.id — NOT NULL
  • Order_Product_id — NUMBER — Foreign key → Order_Product.id — NOT NULL

Review_Photo (후기 사진)

  • id (review_photo_id) — NUMBER — Primary key — NOT NULL
  • photo_url — VARCHAR2(300) — NOT NULL
  • review_id — NUMBER — Foreign key → Review.id — NOT NULL

Shipping_Address (배송지 주소)

  • id (Shipping_Address_id) — NUMBER — Primary key — NOT NULL
  • user_id (유저 id) — NUMBER — Foreign key → User.id — NOT NULL
  • address (주소) — VARCHAR2(100) — NOT NULL — 규칙 : 주소는 최대 50자 제약 : varchar 길이 제한
  • is_default (기본배송지 여부) — NUMBER(1) — NOT NULL

User (회원)

  • id (user_id) — NUMBER — Primary key — NOT NULL
  • login_id (로그인 아이디) — VARCHAR2(30) — NOT NULL
  • password (비밀번호) — VARCHAR2(256) — NOT NULL
  • name (이름) — VARCHAR2(30) — NOT NULL
  • email (이메일) — VARCHAR2(30) — NOT NULL
  • phone_number (핸드폰 번호) — VARCHAR2(11) — NOT NULL
  • gender (성별) — VARCHAR2(10) — NOT NULL
  • birth (생일) — DATE
  • created_at (생성일시) — DATE — NOT NULL
  • updated_at (수정일시) — DATE — NOT NULL