E_COMMERCE

테이블 (9)

거래내역 (WALLET_TRANSACTION)

  • TRANSACTION_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • WALLET_ID (Key2) — BIGINT — 외래 키 → 지갑.WALLET_ID — NOT NULL
  • TRANSACTION_TYPE (Field) — VARCHAR(50)
  • AMOUNT (Field2) — INT
  • BALANCE_AFTER (Field3) — INT
  • CREATED_AT (Field4) — DATETIME
  • CUSTOMER_ID (Key22) — BIGINT — 외래 키 → 지갑.CUSTOMER_ID — NOT NULL

결제 (PAYMENT)

  • PAYMENT_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • ORDER_ID (Key2) — BIGINT — 외래 키 → 주문.ORDER_ID — NOT NULL
  • AMOUNT (Field2) — INT
  • STATUS (Field) — VARCHAR(50)
  • PAID_AT (Field3) — DATETIME
  • CUSTOMER_ID (Key22) — BIGINT — 외래 키 → 주문.CUSTOMER_ID — NOT NULL

고객 (CUSTOMER)

  • CUSTOMER_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • CUSTOMER_NAME (Field) — VARCHAR(255)
  • CUTOMER_ADDRESS (Field2) — VARCHAR(255)
  • CUSTOMER_PHONE (Field3) — VARCHAR(15)

과일 (FRUIT)

  • FRUIT_ID (Key) — BINGINT — 기본 키 — NOT NULL
  • FRUIT_NAME (Field) — VARCHAR(255)
  • FRUIT_STOCK (Field2) — INT
  • FRUIT_PRICE (Field3) — INT
  • STATUS (Field4) — VARCHAR(50)

주문 (ORDER)

  • ORDER_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • CUSTOMER_ID (Key2) — BIGINT — 외래 키 → 고객.CUSTOMER_ID — NOT NULL
  • ORDER_DATE (Field) — DATETIME
  • TOTAL_AMOUNT (Field2) — INT
  • STATUS (Field3) — VARCHAR(50)

주문한과일 (ORDER_FRUIT)

  • PURCHASE_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • ORDER_ID (Key2) — BIGINT — 외래 키 → 주문.ORDER_ID — NOT NULL
  • CUSTOMER_ID (Key22) — BIGINT — 외래 키 → 주문.CUSTOMER_ID — NOT NULL
  • FRUIT_ID (Key3) — LONG — 외래 키 → 과일.FRUIT_ID — NOT NULL
  • FRUIT_PRICE (Field2) — INT
  • QUANTITY (Field3) — INT
  • SUB_TOAL (Field4) — INT

지갑 (WALLET)

  • WALLET_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • CUSTOMER_ID (Key2) — BIGINT — 외래 키 → 고객.CUSTOMER_ID — NOT NULL
  • BALANCE (Field) — INT

쿠폰 (COUPON)

  • COUPON_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • COUPON_NAME (Field) — VARCHAR(255)
  • DISCOUNT_AMOUNT (Field2) — INT
  • ISSUED_AT (Field3) — DATETIME
  • USED_AT (Field5) — DATETIME
  • EXPIRED_AT (Field4) — DATETIME

쿠폰발급 (COUPON_ISSUE)

  • ISSUE_ID (Key) — BIGINT — 기본 키 — NOT NULL
  • COUPON_ID (Key2) — BIGINT — 외래 키 → 쿠폰.COUPON_ID — NOT NULL
  • CUSTOMER_ID (Key3) — BIGINT — 외래 키 → 고객.CUSTOMER_ID — NOT NULL
  • STATUS (Field) — VARCHAR(50)
  • ISSUED_AT (Field2) — DATETIME