study_okky
Tables (4)
logged_in (로그드인)
- idcheck — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → user.id — NOT NULL
- version — bigint(20) — NOT NULL
- date_created — datetime — NOT NULL
- remote_addr — varchar(255)
managed_user
- id — bigint(20) — Primary key — NOT NULL
- version — bigint(20) — NOT NULL
- id (id2) — bigint(20) — Foreign key → user.id — NOT NULL
oauthid
- id — bigint(20) — Primary key — NOT NULL
- user_id — bigint(20) — Foreign key → user.id — NOT NULL
- version — bigint(20) — NOT NULL
- access_token — varchar(255) — NOT NULL
- provider — varchar(255) — NOT NULL
user (유저\)
- id — bigint(20) — Primary key — NOT NULL
- avatar_id — bigint(20) — NOT NULL
- person_id — bigint(20) — NOT NULL
- version — bigint(20) — NOT NULL
- account_expired — bit(1) — NOT NULL
- account_locked — bit(1) — NOT NULL
- create_ip — varchar(255)
- date_created — datatime — NOT NULL
- date_withdraw — datetime
- enabled — bit(1) — NOT NULL
- last_password_changed — datetime — NOT NULL
- last_update_ip — varchar(255)
- last_updated — datetime — NOT NULL
- password — varchar(255) — NOT NULL
- password_expired — bit(1) — NOT NULL
- username — varchar(15) — NOT NULL
- withdraw — bit(1) — NOT NULL