네패스

테이블 (3)

강사 정보 (Untitled)

    강의 예약 정보 (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)