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