sutda

Tables (4)

GameLog

  • Gameindex (게임번호) — int — Foreign key → Sutda.Gameindex — NOT NULL
  • UserIndex (회원번호) — int — Foreign key → Sutda.UserIndex — NOT NULL
  • GameWL (승리 여부) — boolean
  • Money (유저별 변동금액) — int

Sutda (UserInfo)

  • UserIndex (회원번호) — int — Primary key — NOT NULL
  • UserName (이름) — varchar(10)
  • UserBirth (생년월일) — DATE
  • UserPhone (연락처) — varchar(20)
  • UserEmail (이메일) — varchar(20
  • UserId (아이디) — varchar(20)
  • UserPw (패스워드) — varchar(20)
  • UserDate (가입일시) — DATE
  • UserMoney (보유금액) — int

Sutda (GameInfo)

  • Gameindex (게임번호) — int — Primary key — NOT NULL
  • GameDate (게임시각) — DATE
  • GameMoney (판돈) — int

Sutda (ChatLog)

  • UserIndex (회원번호) — int — Foreign key → Sutda.UserIndex — NOT NULL
  • Gameindex (게임번호) — int — Foreign key → Sutda.Gameindex — NOT NULL
  • ChatDate (채팅 시간) — varchar
  • ChatText (채팅 내용) — varchar