sspj

Tables (7)

Creative (creative)

  • id — Primary key — NOT NULL
  • url
  • setId (set_id) — Foreign key → CreativeSet.id — NOT NULL
  • status

CreativeSet (creative_set)

  • id — Primary key — NOT NULL

Execution (execution)

  • id — Primary key — NOT NULL
  • modelId (model_id) — Foreign key → Model.id — NOT NULL
  • creativeSetId (creative_set_id) — Foreign key → CreativeSet.id — NOT NULL
  • userId (user_id) — Foreign key → User.id — NOT NULL
  • status

ExecutionRow (result)

  • id — Primary key — NOT NULL
  • creativeId (creative_id) — Foreign key → Creative.id — NOT NULL
  • executionId (execution_id) — Foreign key → Execution.id — NOT NULL
  • disapprovedRate (disapproved_rate)

Model (model)

  • id — Primary key — NOT NULL
  • name
  • host

Step (step)

    User (user)

    • id — Primary key — NOT NULL
    • username
    • userId (user_id)