StudyLog

Tables (15)

board

  • b_id — BIGINT — Primary key
  • category — VARCHAR(255)

chat_message

  • id — BIGINT — Primary key
  • study_group_id — BIGINT — Primary key
  • user_email — VARCHAR(255)
  • user_name — VARCHAR(255)
  • content — TEXT
  • created_at — DATETIME

comment

  • c_id — BIGINT — Primary key
  • post_id — BIGINT — NOT NULL
  • u_email — VARCHAR(255) — NOT NULL
  • u_name — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME

curriculum_week

  • id — BIGINT — Primary key
  • study_group_id — BIGINT — Primary key
  • week — INT
  • title — VARCHAR(255)

curriculum_week_topics

  • curriculum_week_id — BIGINT — Primary key
  • topics — VARCHAR(255)

post

  • p_id — BIGINT — Primary key
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • u_email — VARCHAR(255) — NOT NULL
  • u_name — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • board_id — BIGINT
  • view_count — INT

post_tag

  • post_id — BIGINT — Primary key — NOT NULL
  • tag_id — BIGINT — Primary key — NOT NULL

study_detail

  • id — BIGINT — Primary key
  • study_group_id — BIGINT — Primary key
  • category — VARCHAR(255)
  • location — VARCHAR(255)
  • start_date — DATE
  • end_date — DATE
  • u_email — VARCHAR(255)
  • meeting_type — VARCHAR(255)
  • meeting_time — VARCHAR(255)

study_detail_meeting_day

  • study_detail_id — BIGINT — Primary key
  • meeting_day — VARCHAR(255)

study_detail_requirements

  • study_detail_id — BIGINT — Primary key
  • requirements — VARCHAR(255)

study_detail_tags

  • study_detail_id — BIGINT — Primary key
  • tags — VARCHAR(255)

study_detail_tools

  • study_detail_id — BIGINT — Primary key
  • tools — VARCHAR(255)

study_group

  • id — BIGINT — Primary key
  • u_email — VARCHAR(255)
  • u_name — VARCHAR(255) — NOT NULL
  • title — VARCHAR(255)
  • description — TEXT
  • max_member — INT
  • current_member — INT
  • status — VARCHAR(255)
  • created_at — DATETIME

study_member

  • id — BIGINT — Primary key
  • study_id — BIGINT — Primary key — NOT NULL
  • u_email — VARCHAR(255)
  • u_name — VARCHAR(255) — NOT NULL
  • status — VARCHAR(255)
  • applied_at — DATETIME

users

  • u_id — BIGINT — Primary key
  • u_name — VARCHAR(255)
  • u_password — VARCHAR(255)
  • u_email — VARCHAR(255)
  • u_role — VARCHAR(255)
  • deleted_at — DATETIME