e-commerce - 2025-07-15 13:12:34

Tables (6)

CODES (코드관리)

  • CODE_ID (코드아이디) — BIGINT — Primary key — NOT NULL
  • CODE_TYPE (코드타입) — VHARCHAR(20)
  • CODE_VAL1 (코드값1) — VARCHAR(20)
  • CODE_NM1 (코드명1) — VARCHAR(20)

COUPON (쿠폰)

  • COUPON_ID (쿠폰 아이디) — BIGINT — Primary key — NOT NULL
  • COUPON_NAME (쿠폰명) — VARCHAR(30)
  • COUPON_TYPE (쿠폰 타입) — VARCHAR(20)
  • COUNPON_VALUE (할인 정도) — NUMERIC(10,2)
  • COUNT (쿠폰 개수) — INT

COUPON_ISSUE (쿠폰발급)

  • ISSUE_ID (발급 아이디) — BIGINT — Primary key — NOT NULL
  • USER_ID (아이디) — BIGINT — Foreign key → USER.USER_ID — NOT NULL
  • USE_YN (사용여부) — VARCHAR(5)
  • COUPON_ID (쿠폰 아이디) — BIGINT — Foreign key → COUPON.COUPON_ID — NOT NULL

GOODS (상품)

  • GOODS_ID (상품 아이디) — BIGINT — Primary key — NOT NULL
  • GOODS_NAME (상품명) — VARCHAR(20)
  • PRICE (가격) — NUMERIC(10,2)
  • STOCK (재고) — INT
  • GOODS_TYPE (상품타입) — VARCHAR(10)
  • REPRE_GOODS_ID (대표상품ID) — BIGINT

ORDER (주문)

  • ORDER_ID (주문 아이디) — BIGINT — Primary key — NOT NULL
  • GOODS_ID (상품 아이디) — BIGINT — Foreign key → GOODS.GOODS_ID — NOT NULL
  • COUPON_ID (쿠폰 아이디) — BIGINT — Foreign key → COUPON.COUPON_ID — NOT NULL
  • USER_ID (아이디) — BIGINT — Foreign key — NOT NULL
  • ORDER_PRICE (주문 금액) — NUMERIC(10,2)
  • PAY_PRICE (결제 금액) — NUMERIC(10,2)
  • ORDER_STATE (주문 상태) — VARCHAR(10)

USER (사용자)

  • USER_ID (아이디) — BIGINT — Primary key — NOT NULL
  • PWD (비밀번호) — VARCHAR(30)
  • USER_NAME (이름) — VARCHAR(20)
  • BALANCE (잔액) — NUMERIC(10,2)