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)