probono_DB_2
Tables (12)
Admin (Untitled9)
- id (Key) — Primary key — NOT NULL
- login_id (Field) — NOT NULL
- login_pw (Field2) — NOT NULL
- status (Field3) — NOT NULL
- created_at (Field4) — NOT NULL
- updated_at (Field5)
- created_charge_id (Field6) — NOT NULL
- updated_charge_id (Field7)
Class (Untitled4)
- id (Key) — Primary key — NOT NULL — autoincrement
- year (Field) — NOT NULL
- grade (Field2) — NOT NULL
- section (Field3) — NOT NULL
- status (Field4)
- created_at (Field5)
- updated_at (Field6)
- created_charge_id (Field7) — NOT NULL
- updated_charge_id (Field8)
Class_notice (Untitled7)
- id (Key) — Primary key — NOT NULL
- title (Field) — NOT NULL
- content (Field2)
- status (Field4) — NOT NULL
- created_at (Field5) — NOT NULL
- updated_at (Field6)
- class_id (Key4) — Foreign key → Class.id — NOT NULL — autoincrement
- teacher_id (Key3) — Foreign key → Teacher.id — NOT NULL — 성별/순서(000)
- created_charge_id (Field3) — NOT NULL
- updated_charge_id (Field7)
- views (Field8) — NOT NULL
- common_course_id (Key2) — Foreign key → Common_course.id
Common_course (Untitled8)
- id (Key) — Primary key — NOT NULL
- teacher_id (Key3) — Foreign key → Teacher.id — 성별/순서(000)
- status (Field) — NOT NULL
- created_at (Field2) — NOT NULL
- updated_at (Field3)
- created_charge_id (Field4) — NOT NULL
- updated_charge_id (Field5)
- class_id (Key4) — Foreign key → Class.id — NOT NULL — autoincrement
- subject_id (Key2) — Foreign key → Subject.id — NOT NULL — autoincrement
Elective_course (Untitled10)
- id (Key3) — Primary key — NOT NULL
- teacher_id (Key) — Foreign key → Teacher.id — 성별/순서(000)
- status (Field) — NOT NULL
- created_at (Field2) — NOT NULL
- updated_at (Field3)
- subject_id (Key4) — Foreign key → Subject.id — NOT NULL — autoincrement
- created_charge_id (Field4) — NOT NULL
- updated_charge_id (Field5)
Elective_course_notice (Untitled12)
- id (Key) — Primary key — NOT NULL
- title (Field) — NOT NULL
- content (Field2)
- status (Field4) — NOT NULL
- created_at (Field5) — NOT NULL
- updated_at (Field6)
- elective_course_id (Key32) — Foreign key → Elective_course.id — NOT NULL
- teacher_id (Key3) — Foreign key → Teacher.id — NOT NULL — 성별/순서(000)
- created_charge_id (Field3) — NOT NULL
- updated_charge_id (Field7)
- views (Field8) — NOT NULL
Elective_course_student (Untitled11)
- id (Key) — Primary key — NOT NULL
- status (Field) — NOT NULL
- created_at (Field2) — NOT NULL
- updated_at (Field3)
- created_charge_id (Field4) — NOT NULL
- updated_charge_id (Field5)
- elective_course_id (Key32) — Foreign key → Elective_course.id — NOT NULL
- student_id (Key2) — Foreign key → Student.id — NOT NULL — 입학 연도(네팔기준)/성별(남자 : 1, 여자 : 2)/순서(000)
Image (Untitled6)
- id (Key) — Primary key — NOT NULL
- image_path (Field2) — NOT NULL
- teacher_id (Key2) — Foreign key → Teacher.id — 성별/순서(000)
- student_id (Key3) — Foreign key → Subject.id — autoincrement
- class_notice_id (Key4) — Foreign key → Class_notice.id
- notice_id (Key5) — Foreign key → Notice.id
- elective_course_notice_id (Key6) — Foreign key → Elective_course_notice.id
Notice (Untitled5)
- id (Key) — Primary key — NOT NULL
- title (Field) — NOT NULL
- content (Field2)
- status (Field4) — NOT NULL
- created_at (Field5) — NOT NULL
- updated_at (Field6)
- admin_id (Key3) — Foreign key → Admin.id — NOT NULL
- created_charge_id (Field3) — NOT NULL
- updated_charge_id (Field7)
- views (Field8) — NOT NULL
Student (Untitled)
- id (Key) — Primary key — NOT NULL — 입학 연도(네팔기준)/성별(남자 : 1, 여자 : 2)/순서(000)
- login_id (Field) — NOT NULL — unique
- login_pw (Field4) — NOT NULL
- name (Field2) — NOT NULL — 최대 40자
- serial_number (Field3) — NOT NULL — unique
- grade (Field5) — NOT NULL — grade속성 class에서 받아올지 고민
- birth (Field6)
- sex (Field7)
- phone_num (Field8)
- father_phone_num (Field9)
- mother_phone_num (Field10)
- guardians_phone_num (Field11)
- class_id (Key2) — Foreign key → Class.id — autoincrement, 선택적 비식별관계로 NULL 허용
- status (Field16) — NOT NULL
- created_at (Field12) — NOT NULL — 생성된 시각
- updated_at (Field13) — 업데이트 된 시각
- created_charge_id (Field14) — NOT NULL — 생성한 id
- updated_charge_id (Field15) — 업데이트 한 id
- pw_answer (Field18)
Subject (Untitled3)
- id (Key) — Primary key — NOT NULL — autoincrement
- name (Field) — NOT NULL
- is_elective (Field2) — NOT NULL
- status (Field3) — NOT NULL
- created_at (Field4) — NOT NULL
- updated_at (Field5)
- created_charge_id (Field6) — NOT NULL
- updated_charge_id (Field7)
Teacher (Untitled2)
- id (Key) — Primary key — NOT NULL — 성별/순서(000)
- login_id (Field2) — NOT NULL — unique
- login_pw (Field3) — NOT NULL
- name (Field)
- sex (Field4)
- phone_num (Field5)
- class_id (Key2) — Foreign key → Class.id — autoincrement
- status (Field10) — NOT NULL
- created_at (Field6) — NOT NULL
- updated_at (Field7)
- created_charge_id (Field8) — NOT NULL
- updated_charge_id (Field9)
- birth (Field11)
- pw_answer (Field13)