DailyOne

Tables (5)

Completed_Mission

  • User_Index — Int — Foreign key → User.User_Index — NOT NULL
  • Mission_Index — Int
  • Title — String
  • Contents — String
  • Completed_Time — Time
  • Mission_Divider — Boolean
  • File_Route — String

Invite_Code

  • User_Index — Int — Foreign key → User.User_Index — NOT NULL
  • Invite_Code — Hash
  • Availablity — Boolean

Sys_Mission

  • Sys_Mission_Index — Int — Primary key — NOT NULL
  • Title — String
  • Contents — String
  • Time_Limit — Time
  • Mission_Divider — 0

User

  • User_Index — Int — Primary key — NOT NULL
  • ID (User_ID) — String
  • PW (User_PW) — String
  • User_Email — String
  • User_EXP[Level] — Int
  • System_Mission_Judge — Boolean
  • User_Mission_Cnt — Int
  • Wait_Switch — Boolean
  • Response_Reported_Cnt — Int
  • Invite_Code_Cnt — Int
  • Request_Cnt — Int
  • Field — Boolean

User_Mission

  • User_Mission_Index — Int — Primary key — NOT NULL
  • User_Index — Int — Foreign key → User.User_Index — NOT NULL
  • Title — String
  • Contents — String
  • Time_Limit — Time
  • Process_Divider — Boolean
  • Mission_Divider — 1
  • Mission_Rejected_Cnt — Int
  • Mission_Reported_Cnt — Int
  • Status — Int