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