SWithMe
Tables (13)
attendance
- attendance_id — int(11) — Primary key — NOT NULL
- attendance_user_nickname — varchar(20) — Foreign key → user_info.user_nickname — NOT NULL
- attendance_date — char(6) — NOT NULL
board
- board_id — int(11) — Primary key — NOT NULL
- board_category — int(11) — Foreign key → category.category_id — NOT NULL
- board_writer — varchar(20) — Foreign key → user_info.user_nickname — NOT NULL
- board_title — text — NOT NULL
- board_content — text — NOT NULL
- board_date — datetime — NOT NULL
- board_view — int(11) — NOT NULL
- board_liked — int(11) — NOT NULL
category
- category_id — int(11) — Primary key — NOT NULL
- category_name — varchar(50) — NOT NULL
default_profile_img
- default_profile_img_id — int(11) — Primary key — NOT NULL
- default_profile_img_data — longblob — NOT NULL
group_info
- group_id — int(11) — Primary key — NOT NULL
- group_name — varchar(50) — NOT NULL
- group_category — int(11) — Foreign key → category.category_id — NOT NULL
- group_daily_goal — int(11)
- group_password — char(64)
- group_goal_date — datetime
- group_max_member_count — int(11) — NOT NULL
- group_cur_member_count — int(11) — NOT NULL
- group_master_nickname — varchar(20) — Foreign key → user_info.user_nickname — NOT NULL
- group_profile_img — longblob
- group_notice — text
- group_created_date — datetime
- group_goal_title — text
group_member
- group_member_id — int(11) — Primary key — NOT NULL
- group_member_group_id — int(11) — Foreign key → group_info.group_id — NOT NULL
- group_member_user_nickname — varchar(20) — Foreign key → user_info.user_nickname — NOT NULL
- group_member_is_master — tinyint(1) — NOT NULL
liked
- liked_id — int(11) — Primary key — NOT NULL
- liked_board_id — int(11) — Foreign key → board.board_id — NOT NULL
- liked_user_nickname — varchar(20) — Foreign key → user_info.user_nickname — NOT NULL
reply
- reply_id — int(11) — Primary key — NOT NULL
- reply_board_id — int(11) — Foreign key → board.board_id — NOT NULL
- reply_writer — varchar(20) — Foreign key → user_info.user_nickname — NOT NULL
- reply_content — text — NOT NULL
- reply_date — datetime — NOT NULL
time_daily
- time_daily_id — int(11) — Primary key — NOT NULL
- time_daily_user_nickname — varchar(20) — Foreign key → user_info.user_nickname — NOT NULL
- time_daily_year_month_day — char(6) — NOT NULL
- time_daily_time — int(11) — NOT NULL
- time_daily_action — int(11) — NOT NULL
time_hourly
- time_hourly_id — int(11) — Primary key — NOT NULL
- time_hourly_user_nickname — varchar(20) — Foreign key → user_info.user_nickname — NOT NULL
- time_hourly_year_month_day_hour — char(8) — NOT NULL
- time_hourly_time — int(11) — NOT NULL
time_monthly
- time_monthly_id — int(11) — Primary key — NOT NULL
- time_monthly_user_nickname — varchar(20) — Foreign key → user_info.user_nickname — NOT NULL
- time_monthly_year_month — char(4) — NOT NULL
- time_monthly_time — int(11) — NOT NULL
todo
- todo_id — int(11) — Primary key — NOT NULL
- todo_user_nickname — varchar(20) — Foreign key → user_info.user_nickname — NOT NULL
- todo_content — text — NOT NULL
- todo_finish — tinyint(4) — NOT NULL
- todo_date — datetime — NOT NULL
user_info
- user_id — varchar(50) — Primary key — NOT NULL
- user_nickname — varchar(20) — NOT NULL
- user_password — char(64)
- user_message — text
- user_profile_img — longblob
- user_type — varchar(10)
- user_is_studying — tinyint(1) — NOT NULL