erdia 3.6.0

tbl_user (User) #

tbl_user(User) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int



Update # first_name # firstName
*varchar(256)

utf8mb4
user firstname
Update # last_name # lastName
*varchar(256)

utf8mb4

Update # is_active # isActive
*boolean


line1
line2
line3
# photo_id # photo FK int NULLABLE

tbl_photo (Photo) #

tbl_photo(Photo) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int



Update # title # title
*varchar(512)

utf8mb4
photo title
Update # description # description
*varchar(2048)

utf8mb4
photo description
Update # width # width
*int



Update # height # height
*int



tbl_license (License) #

tbl_license(License) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int



Update # title # title UK
*varchar(512)

utf8mb4
organization title
# weight # weight *double-precision sort weight
Update # code # code UK
*varchar(200)

utf8mb4
organization code
Update # description # description
*varchar(2048)

utf8mb4
organization description
Update # expire # expire
*datetime



# user_id # user FK int NULLABLE
tbl_license(License) indices
  Database Name Property Name Unique Columns
# uk_license_code # uk_license_code Unique
  • code
  • title

tbl_organization (Organization) #

tbl_organization(Organization) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int



Update # title # title
*varchar(512)

utf8mb4
organization title
Update # description # description
*varchar(2048)

utf8mb4
organization description
# supports # supports *simple-json organization supports other organization
Update # expire # expire
*datetime



tbl_organization(Organization) indices
  Database Name Property Name Unique Columns
# idx_organization_title # idx_organization_title
  • title
  • description

tbl_mtm_license_organization (tbl_mtm_license_organization) #

tbl_mtm_license_organization(tbl_mtm_license_organization) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # license_id # license_id PK FK
*int



Update # organization_id # organization_id PK FK
*int



tbl_mtm_license_organization(tbl_mtm_license_organization) indices
  Database Name Property Name Unique Columns
# IDX_5baaf0c98029c3d9aea96e3aaf # IDX_5baaf0c98029c3d9aea96e3aaf
  • license_id
# IDX_8e1605d88a692638e20e0a4111 # IDX_8e1605d88a692638e20e0a4111
  • organization_id

erdia 3.5.0

tbl_user (User) #

tbl_user(User) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int



Update # first_name # firstName
*varchar(256)

utf8mb4
user firstname
Update # last_name # lastName
*varchar(256)

utf8mb4

Update # is_active # isActive
*boolean


line1
line2
line3
# photo_id # photo FK int NULLABLE

tbl_photo (Photo) #

tbl_photo(Photo) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int



Update # title # title
*varchar(512)

utf8mb4
photo title
Update # description # description
*varchar(2048)

utf8mb4
photo description
Update # width # width
*int



Update # height # height
*int



tbl_license (License) #

tbl_license(License) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int



Update # title # title UK
*varchar(512)

utf8mb4
organization title
# weight # weight *double-precision sort weight
Update # code # code UK
*varchar(200)

utf8mb4
organization code
Update # description # description
*varchar(2048)

utf8mb4
organization description
Update # expire # expire
*datetime



# user_id # user FK int NULLABLE
tbl_license(License) indices
  Database Name Property Name Unique Columns
# uk_license_code # uk_license_code Unique
  • code
  • title

tbl_organization (Organization) #

tbl_organization(Organization) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int



Update # title # title
*varchar(512)

utf8mb4
organization title
Update # description # description
*varchar(2048)

utf8mb4
organization description
# supports # supports *simple-json organization supports other organization
Update # expire # expire
*datetime



tbl_organization(Organization) indices
  Database Name Property Name Unique Columns
# idx_organization_title # idx_organization_title
  • title
  • description

tbl_mtm_license_organization (tbl_mtm_license_organization) #

tbl_mtm_license_organization(tbl_mtm_license_organization) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # license_id # license_id PK FK
*int



Update # organization_id # organization_id PK FK
*int



tbl_mtm_license_organization(tbl_mtm_license_organization) indices
  Database Name Property Name Unique Columns
# IDX_5baaf0c98029c3d9aea96e3aaf # IDX_5baaf0c98029c3d9aea96e3aaf
  • license_id
# IDX_8e1605d88a692638e20e0a4111 # IDX_8e1605d88a692638e20e0a4111
  • organization_id

erdia 3.4.1

tbl_user (User) #

tbl_user(User) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int



Update # first_name # firstName
*varchar(256)

utf8mb4
user firstname
Update # last_name # lastName
*varchar(256)

utf8mb4

Update # is_active # isActive
*boolean


line1
line2
line3
# photo_id # photo FK int NULLABLE

tbl_photo (Photo) #

tbl_photo(Photo) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int



Update # title # title
*varchar(512)

utf8mb4
photo title
Update # description # description
*varchar(2048)

utf8mb4
photo description
Update # width # width
*int



Update # height # height
*int



tbl_license (License) #

tbl_license(License) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int



Update # title # title UK
*varchar(512)

utf8mb4
organization title
# weight # weight *double-precision sort weight
Update # code # code UK
*varchar(200)

utf8mb4
organization code
Update # description # description
*varchar(2048)

utf8mb4
organization description
Update # expire # expire
*datetime



# user_id # user FK int NULLABLE
tbl_license(License) indices
  Database Name Property Name Unique Columns
# uk_license_code # uk_license_code Unique
  • code
  • title

tbl_organization (Organization) #

tbl_organization(Organization) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int



Update # title # title
*varchar(512)

utf8mb4
organization title
Update # description # description
*varchar(2048)

utf8mb4
organization description
# supports # supports *simple-json organization supports other organization
Update # expire # expire
*datetime



tbl_organization(Organization) indices
  Database Name Property Name Unique Columns
# idx_organization_title # idx_organization_title
  • title
  • description

tbl_mtm_license_organization (tbl_mtm_license_organization) #

tbl_mtm_license_organization(tbl_mtm_license_organization) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # license_id # license_id PK FK
*int



Update # organization_id # organization_id PK FK
*int



tbl_mtm_license_organization(tbl_mtm_license_organization) indices
  Database Name Property Name Unique Columns
# IDX_5baaf0c98029c3d9aea96e3aaf # IDX_5baaf0c98029c3d9aea96e3aaf
  • license_id
# IDX_8e1605d88a692638e20e0a4111 # IDX_8e1605d88a692638e20e0a4111
  • organization_id

erdia 3.4.0

tbl_user (User) #

tbl_user(User) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int
int


Update # first_name # firstName
*varchar(256)
varchar(256)
utf8mb4
user firstname
Update # last_name # lastName
*varchar(256)
varchar(256)
utf8mb4

Update # is_active # isActive
*boolean
boolean

line1
line2
line3
# photo_id # photo FK int NULLABLE

tbl_photo (Photo) #

tbl_photo(Photo) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int
int


Update # title # title
*varchar(512)
varchar(512)
utf8mb4
photo title
Update # description # description
*varchar(2048)
varchar(2048)
utf8mb4
photo description
Update # width # width
*int
int


Update # height # height
*int
int


tbl_license (License) #

tbl_license(License) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int
int


Update # title # title UK
*varchar(512)
varchar(512)
utf8mb4
organization title
Add # weight # weight *double-precision sort weight
Update # code # code UK
*varchar(200)
varchar(200)
utf8mb4
organization code
Update # description # description
*varchar(2048)
varchar(2048)
utf8mb4
organization description
Update # expire # expire
*datetime
datetime


# user_id # user FK int NULLABLE
tbl_license(License) indices
  Database Name Property Name Unique Columns
# uk_license_code # uk_license_code Unique
  • code
  • title

tbl_organization (Organization) #

tbl_organization(Organization) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # id # id PK
*int
int


Update # title # title
*varchar(512)
varchar(512)
utf8mb4
organization title
Update # description # description
*varchar(2048)
varchar(2048)
utf8mb4
organization description
Add # supports # supports *simple-json organization supports other organization
Update # expire # expire
*datetime
datetime


tbl_organization(Organization) indices
  Database Name Property Name Unique Columns
# idx_organization_title # idx_organization_title
  • title
  • description

tbl_mtm_license_organization (tbl_mtm_license_organization) #

tbl_mtm_license_organization(tbl_mtm_license_organization) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
Update # license_id # license_id PK FK
*int
int


Update # organization_id # organization_id PK FK
*int
int


tbl_mtm_license_organization(tbl_mtm_license_organization) indices
  Database Name Property Name Unique Columns
# IDX_5baaf0c98029c3d9aea96e3aaf # IDX_5baaf0c98029c3d9aea96e3aaf
  • license_id
# IDX_8e1605d88a692638e20e0a4111 # IDX_8e1605d88a692638e20e0a4111
  • organization_id

erdia 3.3.1

tbl_user (User) #

tbl_user(User) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
# id # id PK int
# first_name # firstName varchar(256) utf8mb4 user firstname
# last_name # lastName varchar(256) utf8mb4
# is_active # isActive boolean line1
line2
line3
# photo_id # photo FK int NULLABLE

tbl_photo (Photo) #

tbl_photo(Photo) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
# id # id PK int
# title # title varchar(512) utf8mb4 photo title
# description # description varchar(2048) utf8mb4 photo description
# width # width int
# height # height int

tbl_license (License) #

tbl_license(License) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
# id # id PK int
# title # title UK varchar(512) utf8mb4 organization title
# code # code UK varchar(200) utf8mb4 organization code
# description # description varchar(2048) utf8mb4 organization description
# expire # expire datetime
# user_id # user FK int NULLABLE
tbl_license(License) indices
  Database Name Property Name Unique Columns
# uk_license_code # uk_license_code Unique
  • code
  • title

tbl_organization (Organization) #

tbl_organization(Organization) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
# id # id PK int
# title # title varchar(512) utf8mb4 organization title
# description # description varchar(2048) utf8mb4 organization description
# expire # expire datetime
tbl_organization(Organization) indices
  Database Name Property Name Unique Columns
# idx_organization_title # idx_organization_title
  • title
  • description

tbl_mtm_license_organization (tbl_mtm_license_organization) #

tbl_mtm_license_organization(tbl_mtm_license_organization) columns
  Database Name Property Name Attribute Type Nullable Charset Comment
# license_id # license_id PK FK int
# organization_id # organization_id PK FK int
# organization_id # organization_id PK FK int
# license_id # license_id PK FK int
tbl_mtm_license_organization(tbl_mtm_license_organization) indices
  Database Name Property Name Unique Columns
# IDX_5baaf0c98029c3d9aea96e3aaf # IDX_5baaf0c98029c3d9aea96e3aaf
  • license_id
# IDX_8e1605d88a692638e20e0a4111 # IDX_8e1605d88a692638e20e0a4111
  • organization_id