dental_friends

Tables (11)

admin (관리자)

  • id — BIGINT — Primary key — NOT NULL
  • identifier — VARCHAR(10)
  • password (passsword) — VARCHAR(20)
  • role — VARCHAR(10)

allergy (알르레기)

  • id — BIGINT — Primary key — NOT NULL
  • menu_id — BIGINT — Foreign key → lunch_menu.lunch_id — NOT NULL
  • allergy_num — INT

content (콘텐츠)

  • id — BIGINT — Primary key — NOT NULL
  • image — VARCHAR(200)
  • title — VARCHAR(50)
  • attachment — VARCHAR(200)
  • type — VARCHAR(10)
  • text — TEXT

dental_chek (양치체크)

  • id — BIGINT — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student.id — NOT NULL
  • check — BOOLEAN
  • date — DATE

home_content (홈 콘텐츠)

  • id — BIGINT — Primary key — NOT NULL
  • attachment — VARCHAR(200)
  • type — VARCHAR(10)
  • created_by — VARCHAR(10)

lunch (점심)

  • id — BIGINT — Primary key — NOT NULL
  • school_id — BIGINT — Foreign key → school.id — NOT NULL
  • date — DATE

lunch_menu (점심메뉴)

  • id — BIGINT — Primary key — NOT NULL
  • lunch_id — BIGINT — Foreign key → lunch.id — NOT NULL
  • menu — VARCHAR(20)

school (학교)

  • id — BIGINT — Primary key — NOT NULL
  • admin_id — BIGINT — Foreign key → admin.id — NOT NULL
  • code — VARCHAR(50)
  • school — VARCHAR(10)

school_content (학교가 사용하는 컨텐츠)

  • id — BIGINT — Primary key — NOT NULL
  • school_id — BIGINT — Foreign key → school.id — NOT NULL
  • content_id — BIGINT — Foreign key → content.id — NOT NULL

school_home_content (학교가 사용하는 홈 컨텐츠)

  • id — BIGINT — Primary key — NOT NULL
  • school_id — BIGINT — Foreign key → school.id — NOT NULL
  • home_content_id — BIGINT — Foreign key → home_content.id — NOT NULL

student (학생)

  • id — BIGINT — Primary key — NOT NULL
  • school_id — BIGINT — Foreign key → school.id — NOT NULL
  • grade — INT
  • class_num — INT
  • student_num — INT
  • name — VARCHAR(10)
  • gender — VARCHAR(1)