kt-market
테이블 (6)
상품 (product)
- Key (product_id) — Int — 기본 키 — NOT NULL
- Field (name) — Varchar — NOT NULL
- Field2 (price) — Int — NOT NULL
- Field (stock) — Int — NOT NULL
- Field2 (type) — Enum — NOT NULL
- Field (created_date) — DateTime — NOT NULL
- Field2 (modified_date) — DateTime — NOT NULL
영수증 (receipt)
- Key (receipt_id) — Int — 기본 키 — NOT NULL
- Field (member_id) — Int — NOT NULL
- Field2 (status) — Enum — NOT NULL
- Field3 (use_point) — Int — NOT NULL
- Field (created_date) — DateTime — NOT NULL
- Field2 (modified_date) — DateTime — NOT NULL
영수증 아이템 (receipt_item)
- Key (receipt_item_id) — Int — 기본 키 — NOT NULL
- Key (receipt_id) — Int — 외래 키 → 영수증.Key — NOT NULL
- Field (product_id) — Int — NOT NULL
- Field2 (product_name) — Varchar — NOT NULL
- Field3 (product_price) — Int — NOT NULL
- Field (quantity) — Int — NOT NULL
- Field2 (created_date) — DateTime — NOT NULL
- Field (modified_date) — DateTime — NOT NULL
회원 (member)
- 키 (member_id) — Int — 기본 키 — NOT NULL
- (member_point_id) — Int — 외래 키 → 회원 포인트.member_point_id — NOT NULL
- (user_id) — Varchar — NOT NULL
- (password) — Varchar — NOT NULL
- (role) — Varchar — NOT NULL
- (grade) — Enum — NOT NULL
- Field (created_date) — DateTime — NOT NULL
- Field (modified_date) — DateTime
회원 포인트 (member_point)
- (member_point_id) — Int — 기본 키 — NOT NULL
- (available_point) — Int — NOT NULL
- (accumulated_point) — Int — NOT NULL
- Field (created_date) — DateTime — NOT NULL
- Field2 (modified_date) — DateTime — NOT NULL
회원 포인트 아이템 (member_point_item)
- (member_point_item_id) — Int — 기본 키 — NOT NULL
- (member_point_id) — Int — 외래 키 → 회원 포인트.member_point_id — NOT NULL
- (point) — Int — NOT NULL
- (type) — Enum — NOT NULL
- Field (created_date) — DateTime — NOT NULL
- Field2 (modified_date) — DateTime — NOT NULL