table login:
  int user_id
  varchar(255) authentication_id
  varchar(255) email_address
  varchar(255) password_hash
  primary_key=user_id
  index email_address=email_address
  index authentication_id=authentication_id

table application_user:
  int user_id
  varchar(255) user_name
  varchar(63) role
  text biography
  varchar(255) image_path
  varchar(255) first_name
  varchar(255) last_name
  varchar(255) institution
  varchar(255) country
  varchar(255) activity
  int interest_Aneurysm
  int interest_AVM
  int interest_AIS
  int interest_cSDH
  int interest_Others
  int dashboard_featured
  int dashboard_recent
  int dashboard_popular
  int mailing_Aneurysm
  int mailing_AVM
  int mailing_AIS
  int mailing_cSDH
  int mailing_Others
  primary_key=user_id
  auto_number=user_id

table user_department:
  int user_id
  varchar(63) department
  primary_key=user_id;department

table message:
  int message_id
  int parent_message_id
  int user_id
  int message_count
  int has_attachments
  varchar(63) status
  varchar(255) department
  varchar(255) subject
  datetime creation_date
  text body
  primary_key=message_id
  auto_number=message_id
  index parent_message_id=parent_message_id

table message_attachment:
  int attachment_id
  int message_id
  int parent_message_id
  varchar(255) filename
  varchar(255) path
  primary_key=attachment_id
  auto_number=attachment_id
  index message_id=message_id

table message_expert:
  int message_id
  int expert_id
  primary_key=message_id;expert_id

table message_user_inbox:
  int message_id
  int user_id
  int favourite
  int recycle
  int read_count
  primary_key=message_id;user_id

table language_text:
  int text_id
  int language_id
  text text_string
  primary_key=text_id;language_id

table id_sequence:
  varchar(255) sequence_name
  int sequence_value
  primary_key=sequence_name

table video:
  int video_id
  int language_id
  int featured
  varchar(255) status
  varchar(255) title
  datetime creation_date
  varchar(255) category
  varchar(255) video_type
  text description
  varchar(255) video_url
  varchar(255) thumbnail_url
  varchar(255) animated_url
  varchar(255) author_name
  varchar(255) author_position
  varchar(255) author_hospital
  varchar(255) author_country
  primary_key=video_id
  auto_number=video_id

table video_tag:
  int video_id
  varchar(255) tag
  primary_key=video_id;tag

table video_user:
  int video_id
  int user_id
  int favourite
  datetime view_date
  primary_key=video_id;user_id