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