event setting
Tables (6)
Untitled (e_event)
- id — INT — Primary key — NOT NULL
- name — VARCHAR(50)
- descriptiond (desctiption) — VARCHAR(100)
- event_group_id — INT
- guest_registration_begin_at — TIMESTAMP
- guest_registration_end_at — TIMESTAMP
- event_operation_begin_at — TIMESTAMP
- event_operation_end_at — TIMESTAMP
- event_expiration_at — TIMESTAMP
- guest_limit_count — INT
- Timezone — VARCHAR(50)
- country — VARCHAR(50)
- city — VARCHAR(50)
- address — VARCHAR(200)
- template_id — INT — Foreign key → Untitled2.id — NOT NULL
- guest_enrollment_id — INT — Foreign key → Untitled3.id — NOT NULL
- select_guest_id — INT — Foreign key → Untitled4.id — NOT NULL
- candidate_guest_flag — BOOLEAN
- rsvp_flag — TIMESTAMP
- host — VARCHAR(100)
- event_alias — VARCHAR(50)
- mobile_dashboard_flag — BOOLEAN
- mobile_dashboard_passcode — VARCHAR(20)
- active_flag — BOOLEAN
- created_at — TIMESTAMP
- created_by — INT
- updated_at — TIMESTAMP
- updated_by — INT
Untitled (e_event_domain)
- event_id — INT — Foreign key → Untitled.id — NOT NULL
- domain_id — INT — Foreign key → Untitled.id — NOT NULL
- domain — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMP
- created_by — INT
- updated_at — TIMESTAMP
- updated_by — INT
Untitled (e_sub_domain_name)
- id — INT — Primary key — NOT NULL
- name — VARCHAR(50)
Untitled2 (e_event_setting_template)
- id — INT — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
- description — VARCHAR(200)
- guest_enrollment_id — INT — Foreign key → Untitled4.id — NOT NULL
- select_guest_id — INT — Foreign key → Untitled3.id — NOT NULL
- candidate_guest_flag — BOOLEAN
- rsvp_flag — BOOLEAN — NOT NULL
- moduleIds — VARCHAR(200)
Untitled3 (e_event_select_guest_type)
- id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- description — VARCHAR(200)
Untitled4 (e_event_guest_enrollment_type)
- id — INT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- description — VARCHAR(200)