inhamoim

Tables (14)

account

  • id — bigint — Primary key
  • email_verified — bit — NOT NULL
  • moim_created_by_email — bit — NOT NULL
  • moim_created_by_web — bit — NOT NULL
  • moim_enrollment_result_by_email — bit — NOT NULL
  • moim_enrollment_result_by_web — bit — NOT NULL
  • moim_updated_by_email — bit — NOT NULL
  • moim_updated_by_web — bit — NOT NULL
  • email_check_token_generated_at — datetime(6)
  • joined_at — datetime(6)
  • bio — varchar(255)
  • email — varchar(255)
  • email_check_token — varchar(255)
  • location — varchar(255)
  • name — varchar(255)
  • nickname — varchar(255)
  • occupation — varchar(255)
  • password — varchar(255)
  • url — varchar(255)
  • profile_image — longtext

account_tags

  • account_id — bigint — Primary key — NOT NULL
  • tags_id — bigint — Primary key — NOT NULL

account_zones

  • account_id — bigint — Primary key — NOT NULL
  • zones_id — bigint — Primary key — NOT NULL

enrollment

  • id — bigint — Primary key
  • accepted — bit — NOT NULL
  • attended — bit — NOT NULL
  • enrolled_at — datetime(6)
  • event_id — bigint
  • account_id — bigint

event

  • id — bigint — Primary key
  • limit_of_enrollments — int
  • created_by_id — bigint
  • created_date_time — datetime(6) — NOT NULL
  • end_date_time — datetime(6) — NOT NULL
  • end_enrollment_date_time — datetime(6) — NOT NULL
  • moim_id — bigint
  • start_date_time — datetime(6) — NOT NULL
  • title — varchar(255) — NOT NULL
  • description — longtext
  • event_type — enum

moim

  • id — bigint — Primary key
  • closed — bit — NOT NULL
  • published — bit — NOT NULL
  • recruiting — bit — NOT NULL
  • use_banner — bit — NOT NULL
  • closed_date_time — datetime(6)
  • published_date_time — datetime(6)
  • recruiting_updated_date_time — datetime(6)
  • long_description — varchar(255)
  • path — varchar(255)
  • short_description — varchar(255)
  • title — varchar(255)
  • full_description — longtext
  • image — longtext
  • member_count — int — NOT NULL

moim_managers

  • managers_id — bigint — Primary key — NOT NULL
  • moim_id — bigint — Primary key — NOT NULL

moim_members

  • members_id — bigint — Primary key — NOT NULL
  • moim_id — bigint — Primary key — NOT NULL

moim_tags

  • moim_id — bigint — Primary key — NOT NULL
  • tags_id — bigint — Primary key — NOT NULL

moim_zones

  • moim_id — bigint — Primary key — NOT NULL
  • zones_id — bigint — Primary key — NOT NULL

notification

  • id — bigint — Primary key — NOT NULL
  • checked — bit — NOT NULL
  • created_local_date_time — datetime(6)
  • link — varchar(255)
  • message — varchar(255)
  • notification_type — enum
  • title — varchar(255)
  • account_id — bigint
  • created_date_time — datetime(6)

persistent_logins

  • last_used — datetime(6) — NOT NULL
  • series — varchar(64) — NOT NULL
  • token — varchar(64) — NOT NULL
  • username — varchar(64) — NOT NULL

tag

  • id — bigint — Primary key
  • title — varchar(255) — NOT NULL

zone

  • id — bigint — Primary key
  • city — varchar(255) — NOT NULL
  • local_name_of_city — varchar(255) — NOT NULL
  • province — varchar(255)