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)