ppuya

Tables (8)

Breed (breed)

  • Breed ID (breed_id) — INT(11) — Primary key — NOT NULL
  • Breed Name (breed_name) — VARCHAR(255)

Coin Exchange (coin_ex)

  • Exchange ID (ex_id) — INT(11) — Primary key — NOT NULL
  • Registration ID (reg_id) — INT(11) — Foreign key → Register.Registration ID — NOT NULL
  • Status (ex_status) — INT(3)
  • Customer User ID (s_user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Supplier User ID (c_user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Customer Pet ID (s_pet_id) — INT(11) — Foreign key → Pet.Pet ID — NOT NULL
  • Supplier Pet ID (c_pet_id) — INT(11) — Foreign key → Pet.Pet ID — NOT NULL
  • Customer Coin Quantity (s_ex_quantity) — UNSIGNED INT(3)
  • Supplier Coin Quantity (c_ex_quantity) — UNSIGNED INT(3)
  • Organization ID (org_id) — INT(11) — Foreign key → User.Organization ID — NOT NULL
  • Breed ID (breed_id) — INT(11) — Foreign key → Pet.Breed ID — NOT NULL

OT (ot)

  • OT ID (ot_id) — INT(11) — Primary key — NOT NULL
  • Registration ID (reg_id) — INT(11) — Foreign key → Register.Registration ID — NOT NULL
  • Status (ot_status) — INT(3)
  • Customer User ID (c_user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Supplier User ID (s_user_id) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Pet ID (pet_id) — INT(11) — Foreign key → Pet.Pet ID — NOT NULL
  • Organization ID (org_id) — INT(11) — Foreign key → User.Organization ID — NOT NULL
  • Breed ID (breed_id) — INT(11) — Foreign key → Pet.Breed ID — NOT NULL

Organization (organization)

  • Organization ID (org_id) — INT(11) — Primary key — NOT NULL
  • Server ID (server_id) — INT(11) — Foreign key → Server.Server ID — NOT NULL
  • Organization Name (ord_name) — VARCHAR(255)

Pet (pet)

  • Pet ID (pet_id) — INT(11) — Primary key — NOT NULL
  • Breed ID (breed_id) — INT(11) — Foreign key → Breed.Breed ID — NOT NULL
  • Pet Name (pet_name) — VARCHAR(255)
  • Soul Grade (soul_grade) — INT(11)

Register (register)

  • Registration ID (reg_id) — INT(11) — Primary key — NOT NULL
  • Registered Date (reg_date) — TIMESTAMP
  • Registered By (reg_by) — INT(11) — Foreign key → User.User ID — NOT NULL
  • Modified Date (mod_date) — TIMESTAMP
  • Modified By (mod_by) — INT(11) — Foreign key → User.User ID — NOT NULL

Server (server)

  • Server ID (server_id) — INT(11) — Primary key — NOT NULL
  • Server Name (server_name) — VARCHAR(255)

User (user)

  • User ID (user_id) — INT(11) — Primary key — NOT NULL
  • Organization ID (org_id) — INT(11) — Foreign key → Organization.Organization ID — NOT NULL
  • In-game ID (user_ingame_id) — VARCHAR(255) — NOT NULL
  • Password (user_pwd) — VARCHAR(128)
  • Login Counter (user_login_count) — INT(11)
  • Rank (user_rank) — INT(1)