gsstable
Tables (9)
BOSSHUNTINGATPARTYTAB (Untitled6)
- BHPNUM — integer — Primary key — NOT NULL
- PARTYNUM — integer — Foreign key → PARTYTAB.PARTYNUM — NOT NULL
- BOSSNUM — integer — Foreign key → BOSSTAB.BOSSNUM — NOT NULL
BOSSTAB (Untitled2)
- BOSSNUM — integer — Primary key — NOT NULL
- BOSSNAME — varchar(128)
- BOSSIMAGEPATH — varchar(255)
- BOSSGRADE — varchar(64)
GSSUSERTAB (Untitled)
- GSSUSERNUM — integer — Primary key — NOT NULL
- GSSUSERID — varchar(128)
- EMAIL — varchar(64)
- USERPASSWOR (USERPASSWORD) — varchar(64)
- USERPHONE — varchar(64)
- PRIVILGE — varchar(16)
- USERNAME — varchar(128)
ITEM (Untitled9)
- ITEMNUM — integer — Primary key — NOT NULL
- CLASSIFICATION — varchar(64)
- ITEMNAME — varchar(255)
- ITEMIMAGEPATH — varchar(255)
ITEMOFBOSSTAB (Untitled4)
- ITEMOFBOOSNUM — integer — Primary key — NOT NULL
- BOSSNUM — integer — Foreign key → BOSSTAB.BOSSNUM — NOT NULL
- ITEMNUM — integer — Foreign key → ITEM.ITEMNUM — NOT NULL
MEMBEROFPARTYTAB (Untitled3)
- MEMBEROFPARTYNUM — integer — Primary key — NOT NULL
- PARTYNUM (PARTYNUM2) — integer — Foreign key → PARTYTAB.PARTYNUM — NOT NULL
- GSSUSERNUM — integer — Foreign key → GSSUSERTAB.GSSUSERNUM — NOT NULL
- CHRATERNAME — VARCHAR(128)
- PARTYLEADER — BOOLEAN
- DIVISIONPERCENT — VARCHAR(32)
PARTYGETITEMTAB (Untitled8)
- PGIKEY — integer — Primary key — NOT NULL
- ITEMNUM — integer — Foreign key → ITEM.ITEMNUM — NOT NULL
- PARTYNUM — integer — Foreign key → PARTYTAB.PARTYNUM — NOT NULL
- RESULTDATE — DATE
- ITEMSALEPRICE (ITEMSALEPRIVE) — VARCHAR(128)
- RESULTSTAT — BOOLEAN
PARTYTAB (Untitled5)
- PARTYNUM — integer — Primary key — NOT NULL
- PARTYNAME — varchr(128)
RESULTTAB (Untitled7)
- RESULTTABNUM — integer — Primary key — NOT NULL
- MEMBEROFPARTYNUM — integer — Foreign key → MEMBEROFPARTYTAB.MEMBEROFPARTYNUM — NOT NULL
- PGIKEY — integer — Foreign key → PARTYGETITEMTAB.PGIKEY — NOT NULL
- GSSUSERNUM — integer — Foreign key → GSSUSERTAB.GSSUSERNUM — NOT NULL
- PARTYMEMBERCOUNT — integer
- RESULTDATE — DATE
- RESULTPRICE — VARCHAR(128)