"""DB related constants."""

# fact_conflict table columns
ROW_ID = 'row_id'
PARTNER_ID = 'partner_id'
PARTNER_ASSET_ID = 'partner_asset_id'
ISRC = 'isrc'
TUID = 'tuid'
VENDOR_ID = 'vendor_id'
SUBACCOUNT_ID = 'subaccount_id'
TERRITORY = 'territory'
TERRITORY_STANDARD = 'territory_standard'
CONFLICTING_OWNER = 'conflicting_owner'
CONFLICT_DATE = 'conflict_date'
PROCESSED_DATETIME = 'processed_datetime'
RESOLVED_DATETIME = 'resolved_datetime'

# action table columns
CONFLICT_ID = 'conflict_id'
ACTION = 'action'
ACTION_DATE = 'action_date'
REASON = 'reason'
ADDITIONAL_INFORMATION = 'additional_information'
ACCOUNT_ID = 'account_id'
ACCOUNT_TYPE = 'account_type'
ELASTICSEARCH_ID = 'es_id'

# Allowed actions
RELEASE = 'release'
ASSERT = 'assert'
NUMBER_OF_ROWS_INSERTED = 'number of rows inserted'
NUMBER_OF_ROWS_UPDATED = 'number of rows updated'


# fact_conflict_youtube table columns
ASSET_ID = 'asset_id'
RECENT_DAILY_AVERAGE = 'recent_daily_average'

SNOWFLAKE_DATE_FORMAT = '%Y-%m-%d %H:%M:%S'

# conflict_status table columns
GROUPED_CONFLICT_ID = 'grouped_conflict_id'
STATUS = 'status'
UPDATE_DATE = 'update_date'
USER_ID = 'user_id'
NOTE = 'note'