table

Tables (4)

Club (')

  • Key (Club_ID) — Primary key — NOT NULL
  • Field2 (팀원 ID) — Primary key
  • (Club_Name)
  • (Club_HC)
  • (종목)
  • (팀장 유저)
  • (활동지역)

Game (,)

  • Key (Game_Num) — Primary key — NOT NULL
  • (Game_Date)
  • (Game_Place)
  • (승패)
  • (팀1 팀원)
  • (팀2 팀원)
  • Key (Club_ID) — Foreign key → Club.Key — NOT NULL
  • Field2 (팀원 ID) — Foreign key → Club.Field2

Game Chat Room (.)

  • Key (Room_Num) — Primary key — NOT NULL
  • (Room_Name)
  • (Room_Address)
  • (Room_HC(인원수))
  • (경기 시각)
  • (Room_GameNum)
  • (팀원)
  • User_ID (Room_Reader) — Char — Foreign key → User.Key — NOT NULL

User

  • Key (User_ID) — Char — Primary key — NOT NULL
  • (User_PW) — Char
  • (User_Nickname) — Char
  • (User_Name) — Char
  • (User_Tel) — Int
  • (User_Age) — Int
  • (User_Region) — Char
  • (User_Sex) — Char
  • (User_Height) — Int
  • (User_Weight) — Int
  • (User_Club) — Char
  • (User_Grade) — Int
  • (User_Email) — Char