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