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)