domain

type Executor struct {
	ID         int64     // BIGSERIAL
	Name       string    // TEXT
	Started    time.Time // TIMESTAMP
	LastActive time.Time // TIMESTAMP
}

type User struct {
	ID            int64          `json:"id"`
	Username      string         `json:"username"`
	Password      string         `json:"password"`
	RetryCount    sql.NullInt32  `json:"retryCount"`
	SessionID     sql.NullString `json:"sessionId"`
	ApiKey        sql.NullString `json:"apiKey"`
	SessionExpiry sql.NullTime   `json:"sessionExpiry"`
	Created       sql.NullTime   `json:"created"`
	Enabled       sql.NullBool   `json:"enabled"`
}

type Workflow struct {
	ID               int64
	Status           string
	ExecutionCount   int
	RetryCount       int
	Created          time.Time
	Modified         time.Time
	NextActivation   sql.NullTime
	Started          sql.NullTime
	ExecutorID       sql.NullString
	ExecutorGroup    string
	WorkflowType     string
	ExternalID       string
	BusinessKey      string
	State            string
	StateVars        sql.NullString
	ParentWorkflowID sql.NullInt64
}

type WorkflowAction struct {
	ID             int64     // BIGSERIAL
	WorkflowID     int64     // BIGSERIAL (foreign key)
	ExecutorID     int64     // BIGINT (foreign key to executors.id)
	ExecutionCount int       // INT
	RetryCount     int       // INT
	Type           string    // TEXT
	Name           string    // TEXT
	Text           string    // TEXT
	DateTime       time.Time // TIMESTAMP
}

type WorkflowDefinition struct {
	Name        string
	Description string
	Created     time.Time
	Updated     time.Time
	FlowChart   string
}