example1

okky erd

Tables (11)

Copy Of Copy Of confirm_email (CopyOfCopyOfUser)

  • id — bigint(20) — Primary key — NOT NULL
  • version — bigint(20) — NOT NULL
  • date_expired — datetime — NOT NULL
  • email — varchar(255) — NOT NULL

Copy Of confirm_email (CopyOfUser)

  • id — bigint(20) — Primary key — NOT NULL
  • version — bigint(20) — NOT NULL
  • date_expired — datetime — NOT NULL
  • email — varchar(255) — NOT NULL

avatar

  • id — bigint(20) — Primary key — NOT NULL
  • version — bigint(20) — NOT NULL
  • activity_point — int(11) — NOT NULL
  • nickname — varchar(20) — NOT NULL
  • official — bit(1)
  • picture — varchar(255) — NOT NULL
  • picture_type — int(11) — NOT NULL

avatar_tag

  • avatar_tags_id — bigint(20) — Foreign key → avatar.id

confirm_email (User)

  • id (user_id) — INT — Primary key — NOT NULL
  • version — bigint(20) — NOT NULL
  • Field

follow

  • follower_id — bigint(20) — Foreign key → avatar.id — NOT NULL
  • following_id — bigint(20) — Foreign key → avatar.id — NOT NULL
  • date_created — datetime — NOT NULL

logged_in

  • id — bigint(20) — Primary key — 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

person

  • id — bigint(20) — Primary key — NOT NULL
  • version — bigint(20) — NOT NULL
  • date_created — datetime — NOT NULL
  • dm_allowed — bit(1) — NOT NULL
  • email — varchar(255) — NOT NULL
  • full_name — varchar(255) — NOT NULL
  • homepage_url — varchar(255)
  • last_updated — datetime — NOT NULL

role

  • id — bigint(20) — Primary key — NOT NULL
  • version — bigint(20) — NOT NULL
  • authority — varchar(255) — NOT NULL

user_role

  • role_id — bigint(20) — Foreign key → role.id — NOT NULL