ㅇㅇㅇㅇㄷ

Tables (11)

edu_apply

  • apply_id — INTEGER — Primary key — NOT NULL
  • member_id — INTEGER — Foreign key → edu_student.member_id
  • lecture_id — INTEGER — Foreign key → edu_lecture.lecture_id
  • created_date — DATETIME

edu_center

  • center_id — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(50)
  • tel — VARCHAR(30)
  • fax — VARCHAR(30)
  • juso_id — INTEGER — Foreign key → edu_juso.juso_id
  • detail_address — VARCHAR(255)

edu_juso

  • juso_id — INTEGER — Primary key — NOT NULL
  • post_no — CHAR(5)
  • basic_address — VARCHAR(255)

edu_lecture

  • lecture_id — INTEGER — Primary key — NOT NULL
  • title — VARCHAR(255)
  • content — VARCHAR(255)
  • quatity — INTEGER
  • start_date — DATE
  • end_date — DATE
  • online — TINYINT
  • room_id — INTEGER — Foreign key → edu_room.room_id
  • member_id — INTEGER — Foreign key → edu_manager.member_id

edu_lecture_teacher

  • lecture_id — INTEGER — Foreign key → edu_lecture.lecture_id — NOT NULL
  • member_id — INTEGER — Foreign key → edu_teacher.member_id — NOT NULL

edu_manager

  • member_id — INTEGER — Foreign key → edu_member.member_id — NOT NULL
  • position — VARCHAR(50)
  • department — VARCHAR(50)
  • fax — VARCHAR(30)

edu_member

  • member_id — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(50)
  • email — VARCHAR(40)
  • tel — VARCHAR(30)
  • created_date — DATETIME

edu_room

  • room_id — INTEGER — Primary key — NOT NULL
  • center_id — INTEGER — Foreign key → edu_center.center_id
  • name — VARCHAR(50)
  • quantity — INTEGER

edu_room_photo

  • romm_photo_id — INTEGER — Primary key — NOT NULL
  • filepath — VARCHAR(255)
  • room_id — INTEGER — Foreign key → edu_room.room_id

edu_student

  • member_id — INTEGER — Foreign key → edu_member.member_id — NOT NULL
  • working — TINYINT
  • jumin — VARCHAR(13)
  • juso_id — INTEGER — Foreign key → edu_juso.juso_id
  • detail_address — VARCHAR(255)

edu_teacher

  • member_id — INTEGER — Foreign key → edu_member.member_id — NOT NULL
  • photo — VARCHAR(255)
  • major — VARCHAR(50)
  • wage — INTEGER