crazy alcade

Tables (8)

Group (group)

  • groupId (g_id) — INT(11) — Primary key — NOT NULL
  • groupName (g_name) — VARCHAR(20)
  • groupPasswd (g_passwd) — VARCHAR(20) — NOT NULL
  • groupType (g_type) — BOOLEAN
  • groupMemberCnt (g_cnt) — INT(11)
  • groupLanguage (g_lang) — VARCHAR(10)
  • groupTimeHour (g_hour) — INT(2)
  • groupTimeMinute (g_min) — INT(2)
  • groupReview (g_review) — BOOLEAN
  • groupMaster (g_master) — VARCHAR(20)
  • groupStartTime (g_start) — DATE
  • problemId (p_id) — INT(11) — Foreign key → Problem.problemId — NOT NULL

GroupChatting (group_chatting)

  • groupChatId (gc_id) — INT(11) — Primary key — NOT NULL
  • groupId (g_id) — INT(11) — Foreign key → Group.groupId — NOT NULL
  • userId (u_id) — VARCHAR(20) — Foreign key → User.userId — NOT NULL
  • groupChatContents (gc_cont) — VARCHAR(1000)
  • groupChatTime (gc_time) — DATETIME

GroupUser (group_user)

  • groupUserId (gu_id) — INT(11) — Primary key — NOT NULL
  • groupId (g_id) — INT(11) — Foreign key → Group.groupId — NOT NULL
  • userId (u_id) — VARCHAR(20) — Foreign key → User.userId — NOT NULL
  • userAnswer (u_answer) — VARCHAR(1000)

Item (item)

  • itemId (i_id) — INT(11) — Primary key — NOT NULL
  • itemName (i_name) — VARCHAR(10)
  • itemDescription (i_des) — VARCHAR(100)
  • itemPrice (i_price) — INT(11)

Problem (problem)

  • problemId (p_id) — INT(11) — Primary key — NOT NULL
  • problemName (p_name) — VARCHAR(20)
  • problemQuestion (p_quest) — VARCHAR(10000)
  • problemAnswer (p_answer) — VARCHAR(10000)

User (user)

  • userId (u_id) — VARCHAR(20) — Primary key — NOT NULL
  • passwd (u_passwd) — VARCHAR(20)
  • userName (u_name) — VARCHAR(20)
  • userLevel (u_level) — VARCHAR(10)
  • userExp (u_exp) — INT(11)
  • userCoin (u_coin) — INT(11)

UserItem (userItem)

  • userItemId (ui_id) — INT(11) — Primary key — NOT NULL
  • userId (u_id) — VARCHAR(20) — Foreign key → User.userId — NOT NULL
  • userItemId (ui_item_id) — INT(11) — Foreign key → Item.itemId — NOT NULL
  • userItemCnt (ui_cnt) — INT(11)

mainChatting (main_chatting)

  • mainChatId (mc_id) — INT(11) — Primary key — NOT NULL
  • userId (u_id) — VARCHAR(20) — Foreign key → User.userId — NOT NULL
  • mainCharContents (mc_cont) — VARCHAR(1000)
  • mainChatTime (mc_time) — DATETIME