D101 v2
Tables (6)
Untitled (account)
- Key (account_number) — NOTNULL — Primary key — NOT NULL
- Field (balance) — NOTNULL
- Field (created_time) — NOTNULL
- Field (password) — NOTNULL
- email — NOTNULL — Foreign key → User.email — NOT NULL
Untitled (character)
- Key (character_idx) — NOTNULL — Primary key — NOT NULL
- Field (type) — NOTNULL
- Field (exp) — NOTNULL
- Field (hp) — NOTNULL
- Field (def) — NOTNULL
- Field (cp) — NOTNULL
- Field (atk) — NOTNULL
- Field (istypical) — NOTNULL
- Field (created_time) — NOTNULL
- Key (user_code) — NOTNULL — Foreign key → Untitled.Key — NOT NULL
Untitled (branch)
- Key (branch_idx) — NOTNULL — Primary key — NOT NULL
- Field (name) — NOTNULL
- Field (address) — NOTNULL
- email (top_user_email) — NOTNULL — Foreign key → User.email — NOT NULL
Untitled (user_game_info)
- Key (user_code) — NOTNULL — Primary key — NOT NULL
- Field (point) — NOTNULL
- email (id) — NOTNULL — Foreign key → User.email — NOT NULL
Untitled2 (transaction_history)
- Key (tx_idx) — NOTNULL — Primary key — NOT NULL
- Field (issued_time) — NOTNULL
- Field (from) — NOTNULL
- Field (to) — NOTNULL
- Field (money) — NOTNULL
- Key (account_number) — NOTNULL — Foreign key → Untitled.Key — NOT NULL
User (user)
- email (id) — NOTNULL — Primary key — NOT NULL
- Field (email)
- Field2 (password) — NOTNULL
- Field (name) — NOTNULL
- Field (nickname) — NOTNULL
- Field (birth_date) — NOTNULL
- Field2 (phone_number) — NOTNULL