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)