OverTheGlass

Tables (10)

Untitled

    auth_pwd

    • auth_pwd_pkey — INT
    • user_fkey — INT
    • salt — VARCHAR(255)
    • pwd — VARCHAR(255)
    • update_date — DATETIME

    auth_social

    • auth_social_pkey — INT
    • user_fkey — INT
    • sns_type — INT
    • sns_id — VARCHAR(255)
    • access_token — VARCHAR(255)
    • update_date — DATETIME

    chatroom

    • chatroom_pkey — INT
    • user_fkey — INT
    • rand_num — BIGINT
    • title — VARCHAR(50) — NOT NULL
    • created_at — DATETIME

    chatroom_text

    • chatroom_text_pkey — INT
    • chatroom_fkey — INT
    • user_fkey — INT
    • text — TEXT
    • nickname — VARCHAR(255)
    • created_at — DATETIME

    login_log

    • login_log_pkey — INT
    • user_fkey — INT
    • status — INT
    • ip — VARCHAR(20)
    • fail_count — INT
    • latest_login_date — DATETIME

    subtitle_setting

    • subtitle_setting_pkey — INT
    • user_setting_fkey — INT
    • color — INT
    • size — INT
    • bold — INT
    • bg_color — INT

    user

    • user_pkey — INT
    • id_email — VARCHAR(128) — NOT NULL
    • login_type — INT
    • status — INT

    user_info

    • user_info_pkey — INT
    • user_fkey — INT
    • name — VARCHAR(40) — NOT NULL
    • birth — INT(11) — NOT NULL
    • gender — INT
    • certificated_email — INT
    • certificated_date — DATETIME
    • join_date — DATETIME — NOT NULL
    • update_date — DATETIME

    user_setting

    • user_setting_pkey — INT
    • user_fkey — INT
    • subtitle — INT
    • nickname — VARCHAR(30) — NOT NULL
    • update_date — DATETIME