산정관
테이블 (6)
Product (PRODUCT)
- Key (product_id) — INTEGER — 기본 키 — NOT NULL
- Field (name) — VARCHAR — NOT NULL
- Field (price) — INTEGER — NOT NULL
- Field (product_type) — VARCHAR — NOT NULL
- Field (condition) — INTEGER — NOT NULL
Untitled (USER)
- Key (user_id) — INTEGER — 기본 키 — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
- Field (name) — VARCHAR — NOT NULL
- Field (password) — VARCHAR — NOT NULL
Untitled (REGISTER)
- Key (register_id) — INTEGER — 기본 키 — NOT NULL
- Key (user_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
- Key (product_id) — INTEGER — 외래 키 → Product.Key — NOT NULL
Untitled (PURCHASE)
- Key (purchase_id) — INTEGER — 기본 키 — NOT NULL
- Field (implemented_at) — DATETIME — NOT NULL
- Key (product_id) — INTEGER — 외래 키 → Product.Key — NOT NULL
- Key (user_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
Untitled (ACCOUNT)
- Key (account_id) — INTEGER — 기본 키 — NOT NULL
- Field (balance) — INTEGER — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
- Key (user_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL
Untitled (CHARGE)
- Key (charge_id) — INTEGER — 기본 키 — NOT NULL
- Field (implemented_at) — DATETIME — NOT NULL
- Field (amount) — INTEGER — NOT NULL
- Key (account_id) — INTEGER — 외래 키 → Untitled.Key — NOT NULL