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