OverTheGlass
Tables (10)
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