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