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)