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