U KhkL@sRddlZddlZddlZddlZddlmZddlm Z m Z Gddde j Z dS)N)settings) migrationsmodelsc@s eZdZdZddeejgZej dde j ddddfd e j dd d d fd e j e jdddddfde jddddfde j dddddfde jddejjdgdfde jddddd fd!e j dd"dd#fd$e j dd%dd#fd&e jdd'dejjjd(fd)e jddd*d+fd,e jd-ejjdgd.fd/e jdd/d0dejj jjd1d2d3fd4e jdd5dejj jjd6ejd7d8fd9e jdd:dejj jjd;ejddejj jjd?ejd@d8fdAe jddAdBdejj jjd1dCd3fgdDdddEdFgdGdHej dIde j ddddfd e j dd d d fd e j e jdddddfde jddddfde j dddddfdJe j ddKdLdMdNfdOe j ddPdLdQdNfde jddRdSdTfdUe jddVdWdTfdXe j ddYdLdZdNfd[e j!dd\d]dTfd^e j"d_d`dafdbe j ddcdLdddNfdee jdddfejjdgdgdhfdie j ddjddkdlddmdnfd4e jdd5dejj jjd6ejd7d8fd9e jdd:dejj jjd;ejddejj jjd?ejd@d8fgdodpdIdqdrdsgdGdHej dtde j ddddfd e j dd d d fd e j e jdddddfde jddddfde j dddddfdue j!dddvddwdxfdye j!ddzdd{dfd|e j"dd}dd~dfd4e jdd5dejj jjd6ejd7d8fd9e jdd:dejj jjd;ejddejj jjd?ejd@d8fg dddtdugdGdHej dde j ddddfd e j dd d d fd e j e jdddddfde jddddfde j dddddfde j!ddddddxfde jddddddfd4e jdd5dejj jjd6ejd7d8fd9e jdd:dejj jjd;ejddejj jjd?ejd@d8fde jddddejj jj#ddddfg dddddgdGdHej dde j ddddfd e j dd d d fd e j e jdddddfde jddddfde j dddddfde jdddddejjdgddfde jddUddddWdfde jddddejj jjddddfd4e jdd5dejj jjd6ejd7d8fd9e jdd:dejj jjd;ejddejj jjd?ejd@d8fde jddddejj jj#ddddfg ddddd ge j$ddgdde j$dgdde j$dgddge j%e &ddddgddHej'd1e j$d/dgdddej'd1e j$d!d$gdddej'd1e j$d)dgdddej'd1e j$dgdddej'd1e j$dAgdddej(d1e j%ddddej(d1e j)e j&de *d$fddddddčdej'de j$dJdOgdddej'de j$dd[gdddej'de j$dUdegdddej'de j$dXdgdddej'de j$dbgdddej'de j$digdddej(de j%ddddej'de j$ddugdddej'de j$dugdddej(de j)e j&de *dyfddddddčdej'de j$ddgdddej'de j$dgdddgZ+dS) MigrationT) campaigns 0001_initial)channelsr Playlists created_atz&Timestamp when this object was createdz Created At) auto_now_add help_text verbose_name updated_atz,Timestamp when this object was last modifiedz Updated At)auto_nowr r idFz!Unique identifier for this object)defaulteditabler primary_key serialize is_deletedz)Whether this object has been soft-deletedz Is Deleted)rr r deleted_atz+Timestamp when this object was soft-deletedz Deleted At)blankr nullr versionz*Version identifier for playlist versioningr)rr validatorsbroadcast_datezScheduled broadcast date)rdb_indexr r start_datez%Start datetime for playlist broadcast)rr rend_datez#End datetime for playlist broadcastxml_filez-Generated XML schedule file for this playlist)rr r upload_tois_draftz/Draft status flag (True=draft, False=published))rrr draft_versionz#Version number for draft management)r rchannelz$The channel this playlist belongs to playlistszchannels.channel)r db_columnr r on_delete related_nameto created_byzUser who created this objectz%(class)s_createdz Created By)rr rr'r(r)r deleted_byz!User who soft-deleted this objectz%(class)s_deletedz Deleted By updated_byz"User who last modified this objectz%(class)s_updatedz Updated By zone_channelz+Specific zone within the channel (optional)zchannels.channelzonePlaylistz -created_atz-id)r verbose_name_pluraldb_tableordering)namefieldsoptionsVerifs networknamez Name of the broadcasting networkz Network Name)rr max_lengthr zonenamezName of the broadcasting zonez Zone Namez)Date when the advertisement was broadcastzBroadcast Date)rr r trafficIdz/Traffic system identifier for the advertisementz Traffic IDspotIdz,Unique identifier for the advertisement spotzSpot IDair_timez%Time when the advertisement was airedzAir Time air_lengthz#Duration of the aired advertisementz Air Length)r r airStatuscodez'Status code indicating broadcast resultzAir Status Coderevisionz+Revision number for the verification recordRevision)rrr rr vercomplete verCompletezVerification completion status2zVerification Complete)rr&rr r8rr zAdvertisement VerificationzAdvertisement Verificationsz-broadcast_datez -air_timez -revisionWindows window_startz$Start time of the advertising windowz Window Start)rrr rr window_endz"End time of the advertising windowz Window Endwindow_durationz"Duration of the advertising windowzWindow Durationplaylistz#The playlist this window belongs towindowszplaylists.playlists)rr&r rr'r(r)r zAdvertising WindowzAdvertising WindowsAvails avail_startz,Start time of the available advertising slotz Avail Start availinwindow availInWindowz1Position or identifier of avail within the windowzAvail in Window)rr&r rr windowz,The advertising window this avail belongs toavailszplaylists.windowsWindowzAvailable SlotzAvailable SlotsAdspotsInAvailpositioninavailpositionInAvailz2Position of the ad spot within the avail (1-based)zPosition in Avail)rr&rr rrr trafficidz+Traffic system identifier for the placement)rr&rr rr adspotz#The advertisement spot being placedplacements_in_availzcampaigns.adspotszAd Spotavailz/The available slot where this ad spot is placedadspots_in_availzplaylists.availsAvailzAd Spot PlacementzAd Spot PlacementsAdspots_in_availadspot_avail_position_idx)r3r2adspot_spot_idxadspot_traffic_idx)positioninavail__isnullF)rWrR unique_adspot_position_per_avail) conditionr3r2)r r/r0r1indexes constraintsplaylist_channel_date_idx) model_nameindexplaylist_datetime_range_idxplaylist_draft_created_idxplaylist_version_idxplaylist_zone_idx)r$rr(unique_playlist_version_per_channel_date)rd constraintstart_date__lt)start_date__isnullT)end_date__isnullTOR) _connectorplaylist_valid_date_range)checkr2verifsverif_network_zone_idxverif_broadcast_air_idxverif_traffic_revision_idxverif_spot_date_idxverif_status_idxverif_complete_idx)r:r;r?&unique_verif_per_traffic_spot_revisionwindow_playlist_start_idxwindow_start_idxwindow_start__lt)window_start__isnullT)window_end__isnullTwindow_valid_time_rangeavail_window_start_idxavail_position_idxN),__name__ __module__ __qualname__initialrswappable_dependencyrAUTH_USER_MODEL dependencies CreateModelr DateTimeField UUIDFielduuiduuid4 BooleanField IntegerFielddjangocorerMinValueValidator DateField FileFieldappsr%utilsplaylist_xml_upload_path ForeignKeydbdeletion DO_NOTHINGSET_NULL CharField TimeField DurationFieldCASCADEIndexUniqueConstraintQAddIndex AddConstraintCheckConstraintF operationsrrA/var/www/html/Focus/src/apps/playlists/migrations/0001_initial.pyr s "$$$""$$$$$$$$$$$&$$$$$. $ $r) apps.playlists.utilsrZdjango.core.validatorsrdjango.db.models.deletionr django.confr django.dbrrrrrrrs