네패스
테이블 (3)
강의 예약 정보 (lecture)
- le_id (Key) — int(11) — 기본 키 — NOT NULL
- le_am_sub_teacher1 (Key2) — varchar(20) — 외래 키 → 유저.mb_id — NOT NULL
- le_am_main_teacher (Field7) — varchar(20)
- le_regions (Field) — varchar(10)
- le_subject (Field2) — varchar(10)
- le_region (Field3) — varchar(10)
- le_location (Field4) — varchar(15)
- le_training_date (Field5) — date
- le_class (Field6) — varchar(5)
- le_am_sub_teacher1 (Field8) — varchar(20)
- le_am_sub_teacher_arr (Field9) — varchar(20)
- le_pm_main_teacher (Field11) — varchar(20)
- le_pm_sub_teacher1 (Field12) — varchar(20)
- le_pm_sub_teacher_arr (Field13) — varchar(20)
- le_datetime (Field15) — datetime
- Field10
유저 (g5_member)
- mb_id (Key2) — varchar(20) — 기본 키 — NOT NULL
- mb_password (Field) — varchar(255)
- mb_name (Field2) — varchar(255)
- mb_nick (Field3) — varchar(255)
- mb_nick_date (Field4) — date
- mb_email (Field5) — varchar(255)
- mb_level (Field6) — tinyint(4)
- mb_today_login (Field7) — datetime
- mb_login_ip (Field8) — varchar(255)
- mb_mailling (Field9) — tinyint(4)
- mb_1 (Field10) — varchar(20)
- mb_2 (Field11) — varchar(20)