curation

Tables (3)

country

  • id — varchar(255) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • language_pack — text — NOT NULL
  • default_country — varchar(255) — NOT NULL
  • default_languagev (default_language) — varchar(255) — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • updated_at — timestamp(6) — NOT NULL

curation

  • id — varchar(36) — Primary key — NOT NULL
  • group_name — varchar(255) — NOT NULL
  • description — varchar(255)
  • is_display — tinyint — NOT NULL
  • delete_reason — varchar(255)
  • curation_type — varchar(255) — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • updated_at (updeated_at) — timestamp(6) — NOT NULL
  • deleted_at — timestamp
  • created_by — varchar(36)
  • updated_by — varchar(36)
  • curation_order — int
  • curation_style — varchar(255) — NOT NULL
  • country — varchar(255) — Foreign key → country.id — NOT NULL

curation_banner

  • id — varchar(36) — Primary key — NOT NULL
  • Field (cuaration_order) — int — NOT NULL
  • banner_name (title) — varchar(255) — NOT NULL
  • image_url (img) — varchar(255) — NOT NULL
  • landing_url (link) — varchar(255) — NOT NULL
  • view_count — int — NOT NULL
  • Field (expose_count) — int — NOT NULL
  • is_display — boolean — NOT NULL
  • updated_at (created_at) — timestamp(6) — NOT NULL
  • created_at (updated_at) — timestamp(6) — NOT NULL
  • id (curation_id) — varchar(36) — Foreign key → curation.id — NOT NULL