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)