ㅇㅇㅇㅇㄷ
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