2WingsWorld

Tables (12)

GameList (Untitled6)

  • GameId (Key) — int — Primary key — NOT NULL
  • GameName (Field) — string(20)
  • GameImgLink (Field2) — string

GameNotice (Untitled5)

  • NoticeIdx (Key2) — int — Primary key — NOT NULL
  • GameId (Key) — int — Foreign key → GameList.GameId — NOT NULL
  • title (Field) — string
  • contents (Field2) — string
  • writeTime (Field3) — string

GameUpdateNote (Untitled7)

  • UpdateNoteIdx (Key) — int — Primary key — NOT NULL
  • GameId (Key2) — int — Foreign key → GameList.GameId — NOT NULL
  • title (Field) — int
  • contents (Field2) — string
  • writeTime (Field3) — string
  • version (Field4) — string

ItemId (Untitled11)

  • ItemId (Key) — int — Primary key — NOT NULL
  • GameId (Key2) — int — Foreign key → GameList.GameId — NOT NULL
  • itemName (Field) — string
  • itemInfo (Field2) — string(Adress)
  • Cost (Field3) — int
  • PayType (Field4) — int
  • canBuyMobileShop (Field5) — boolean
  • sale (Field6) — int

MarblingMapData (Untitled9)

  • MapId (Key) — int — Primary key — NOT NULL
  • MapName (Field) — string
  • MapCostData (Field2) — string(Adress)
  • MapLandNameData (Field3) — string(Adress)

MarblingPlayData (Untitled10)

  • Uid (Key) — int — Foreign key → UserData.Uid — NOT NULL
  • MapId (Key2) — int — Foreign key → MarblingMapData.MapId — NOT NULL
  • WinLose (Field) — boolean
  • playTime (Field2) — string

MarblingUserData (Untitled8)

  • Uid (Key) — int — Foreign key → UserData.Uid — NOT NULL
  • NickName (Field) — string
  • Gold (Field2) — int
  • CP (Field3) — int

OTSMapData (Untitled4)

  • MapId (Key) — int — Primary key — NOT NULL
  • Lap (Field) — int
  • MapName (Field2) — string(20)

OTSPlayData (Untitled3)

  • MapId (Key2) — int — Foreign key → OTSMapData.MapId — NOT NULL
  • Uid (Key) — int — Foreign key → UserData.Uid — NOT NULL
  • LapTime (Field) — string

OTSUserData (Untitled2)

  • Uid (Key) — int — Foreign key → UserData.Uid — NOT NULL
  • NickName (Field) — string(12)
  • Gold (Field2) — int

UserData (Untitled)

  • Uid (Key) — int — Primary key — NOT NULL
  • id (Field) — string(12)
  • pw (Field2) — string(20)
  • isReCheckService (Field3) — boolean
  • WingsCoin (Field4) — int
  • email (Field5) — string

UserInventory (Untitled12)

  • ItemId (Key2) — int — Foreign key → ItemId.ItemId — NOT NULL
  • Uid (Key) — int — Foreign key → UserData.Uid — NOT NULL
  • GameId (Key22) — int — Foreign key → ItemId.GameId — NOT NULL
  • Amount (Field2) — int
  • salePer (Field) — int