StudyLog

Tables (15)

category

  • b_id — LONG — Primary key
  • tag_id — LONG — Foreign key → post_tag.tag_id — NOT NULL
  • post_id (post_id2) — LONG — Foreign key → post_tag.post_id — NOT NULL
  • category — VARCHAR(255)

chat_message

  • id — LONG — Primary key
  • study_id — LONG — Foreign key → study_group.study_id
  • user_email — VARCHAR(255)
  • user_name — VARCHAR(255)
  • content — TEXT
  • created_at — DATETIME

comment

  • c_id — LONG — Primary key
  • post_id (post_id22) — LONG — Foreign key → post_tag.post_id — NOT NULL
  • Key — Foreign key → post_tag.tag_id — 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_id — LONG — Foreign key → study_group.study_id
  • week — INT
  • title — VARCHAR(255)

curriculum_week_topics

  • study_id — LONG — Foreign key → curriculum_week.study_id
  • topics — VARCHAR(255)

post

  • id — LONG — Primary key
  • post_id (post_id2) — LONG — Foreign key → post_tag.post_id — NOT NULL
  • Key — Foreign key → post_tag.tag_id — NOT NULL
  • 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

  • tag_id — LONG — Primary key — NOT NULL
  • post_id (post_id2) — LONG — Foreign key — NOT NULL

study_detail

  • id — LONG — Primary key
  • study_id — LONG — Foreign key → study_group.study_id
  • 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 (study_detail_id2) — LONG — Foreign key → study_detail.id
  • meeting_day — VARCHAR(255)

study_detail_requirements

  • study_detail_requirements_id (study_detail_id) — LONG — Primary key
  • study_detail_id (study_detail_id2) — LONG — Foreign key → study_detail.id
  • requirements — VARCHAR(255)

study_detail_tags

  • study_detail_id — BIGINT — Primary key
  • study_detail_id (study_detail_id2) — LONG — Foreign key → study_detail.id
  • study_id — LONG — Foreign key → study_detail.study_id
  • tags — VARCHAR(255)

study_detail_tools

  • study_detail_id — BIGINT — Primary key
  • study_detail_id (study_detail_id2) — LONG — Foreign key → study_detail.id
  • study_id — LONG — Foreign key → study_detail.study_id
  • tools — VARCHAR(255)

study_group

  • study_id — LONG — 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 — LONG — Primary key
  • study_id — LONG — Foreign key → study_group.study_id
  • u_email — VARCHAR(255)
  • u_name — VARCHAR(255) — NOT NULL
  • status — VARCHAR(255)
  • applied_at — DATETIME

users

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