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