dh

Tables (4)

Untitled

    dongguk_chat_info

    • chat_number — int(11) — Primary key — NOT NULL
    • chat_id — int(11) — NOT NULL
    • student_id — int(10)
    • user_name — varchar(8)
    • chat_content — varchar(100)
    • chat_time — datetime — NOT NULL

    dongguk_room_info

    • room_number — int(11) — Primary key — NOT NULL
    • date_time — datetime — 날짜
    • from — varchar(45)
    • to — varchar(45)
    • gender — varchar(10)
    • maximum — int(1)
    • master — int(10)
    • member1 — int(10)
    • member2 — int(10)
    • member3 — int(10)
    • close — int(1) — NOT NULL — -1=no create, 0 = on create, 1 = close
    • load_weight — int(1)

    dongguk_user_info

    • user_ids — int(11) — Primary key — NOT NULL
    • user_names — varchar(50)
    • user_gender — int(11)
    • user_web_mail — varchar(50) — NOT NULL
    • user_pw — varchar(50)
    • user_kindness — float