teachercabnet
Tables (7)
custom_category
- category_id — BIGINT
- teacher_id — BIGINT — Foreign key → teacher.teacher_id — NOT NULL
- category_name — VARCHAR(50) — NOT NULL
- target_type — ENUM('LESSON', 'POST') — NOT NULL
lesson_plan
- lesson_plan_id — BIGINT
- teacher_id — BIGINT — Foreign key → teacher.teacher_id — NOT NULL
- category_id — BIGINT — Foreign key → custom_category.category_id
- title — VARCHAR(255) — NOT NULL
- content — LONGTEXT
- target_age — INT — NOT NULL
- target_date — DATE — NOT NULL
- image_urls — TEXT
- created_at — TIMESTAMP
post
- post_id — BIGINT
- teacher_id — BIGINT — Foreign key → teacher.teacher_id — NOT NULL
- category_id — BIGINT — Foreign key → custom_category.category_id
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- like_count — INT
- created_at — TIMESTAMP
post_image
- post_image_id — BIGINT
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- image_url — VARCHAR(500) — NOT NULL
student
- student_id — BIGINT
- teacher_id — BIGINT — Foreign key → teacher.teacher_id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- birth_date — DATE — NOT NULL
- profile_image_url — VARCHAR(500)
student_journal
- journal_id — BIGINT
- student_id — BIGINT — Foreign key → student.student_id — NOT NULL
- teacher_id — BIGINT — Foreign key → teacher.teacher_id — NOT NULL
- target_date — DATE — NOT NULL
- daily_note — TEXT
- journal_photo_url — VARCHAR(500)
- report_content — TEXT
- created_at — TIMESTAMP
teacher
- teacher_id — BIGINT
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- kindergarten_name — VARCHAR(100)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP