cook
Tables (43)
Channel
- id — int(11) — Primary key — NOT NULL
- owningUser — int(11) — Foreign key → user.id
- streamKey — varchar(255)
- channelName — varchar(255)
- channelLoc — varchar(255)
- topic — int(11)
- views — int(11)
- currentViewers — int(11)
- record — tinyint(1)
- chatEnabled — tinyint(1)
- chatBG — varchar(255)
- chatTextColor — varchar(10)
- chatAnimation — varchar(255)
- imageLocation — varchar(255)
- offlineImageLocation — varchar(255)
- description — varchar(4096)
- allowComments — tinyint(1)
- protected — tinyint(1)
- channelMuted — tinyint(1)
- showChatJoinLeaveNotification — tinyint(1)
- defaultStreamName — varchar(255)
- autoPublish — tinyint(1)
- rtmpRestream — tinyint(1)
- rtmpRestreamDestination — varchar(4096)
- xmppToken — varchar(64)
- vanityURL — varchar(1024)
Clips
- id — int(11) — Primary key — NOT NULL
- uuid — varchar(255)
- parentVideo — int(11) — Foreign key → RecordedVideo.id
- startTime — float
- endTime — float
- length — float
- views — int(11)
- clipName — varchar(255)
- videoLocation — varchar(255)
- description — varchar(2048)
- thumbnailLocation — varchar(255)
- gifLocation — varchar(255)
- published — tinyint(1)
Guest
- id — int(11) — Primary key — NOT NULL
- UUID — varchar(255)
- last_active_at — datetime
- last_active_ip — varchar(100)
OAuth2Token
- id — int(11) — Primary key — NOT NULL
- name — varchar(40)
- token_type — varchar(40)
- access_token — varchar(2048)
- refresh_token — varchar(2048)
- expires_at — int(11)
- user — int(11) — Foreign key → user.id
RecordedVideo
- id — int(11) — Primary key — NOT NULL
- uuid — varchar(255)
- videoDate — datetime
- owningUser — int(11) — Foreign key → user.id
- channelName — varchar(255)
- channelID — int(11) — Foreign key → Channel.id
- description — varchar(2048)
- topic — int(11)
- views — int(11)
- length — float
- videoLocation — varchar(255)
- thumbnailLocation — varchar(255)
- gifLocation — varchar(255)
- pending — tinyint(1)
- allowComments — tinyint(1)
- published — tinyint(1)
- originalStreamID — int(11)
Stream
- id — int(11) — Primary key — NOT NULL
- uuid — varchar(255)
- startTimestamp — datetime
- linkedChannel — int(11) — Foreign key → Channel.id
- streamKey — varchar(255)
- streamName — varchar(255)
- topic — int(11)
- currentViewers — int(11)
- totalViewers — int(11)
- rtmpServer — int(11) — Foreign key → rtmpServer.id
alembic_version
- version_num — varchar(32) — Primary key — NOT NULL
apikey
- id — int(11) — Primary key — NOT NULL
- description — varchar(255)
- userID — int(11) — Foreign key → user.id
- key — varchar(255)
- type — int(11)
- createdOn — datetime
- expiration — datetime
ban_list
- id — int(11) — Primary key — NOT NULL
- channelLoc — varchar(255)
- userID — int(11) — Foreign key → user.id
channel_ban_list
- id — int(11) — Primary key — NOT NULL
- channelLoc — varchar(255)
- username — varchar(255)
- userUUID — varchar(255)
channel_subs
- id — int(11) — Primary key — NOT NULL
- channelID — int(11) — Foreign key → Channel.id
- userID — int(11) — Foreign key → user.id
channel_upvotes
- id — int(11) — Primary key — NOT NULL
- userID — int(11)
- channelID — int(11) — Foreign key → Channel.id
chat_banned_words
- id — int(11) — Primary key — NOT NULL
- word — varchar(1028)
clip_upvotes
- id — int(11) — Primary key — NOT NULL
- userID — int(11)
- clipID — int(11) — Foreign key → Clips.id
comment_upvotes
- id — int(11) — Primary key — NOT NULL
- userID — int(11)
- commentID — int(11) — Foreign key → videoComments.id
coupon (Untitled3)
- id (Key) — Primary key — NOT NULL
- rastaurantId (id) — int(11) — Foreign key → restaurant.id — NOT NULL
- name (Field)
- expire (Field2)
- price (Field3)
- maxium (Field4)
- isUsed (Field5)
db_version
- id — int(11) — Primary key — NOT NULL
- version — float
edge_streamer
- id — int(11) — Primary key — NOT NULL
- address — varchar(1024)
- port — int(11)
- active — tinyint(1)
- status — int(11)
- loadPct — int(11)
global_webhook
- id — int(11) — Primary key — NOT NULL
- name — varchar(255)
- endpointURL — varchar(2048)
- requestHeader — varchar(4096)
- requestPayload — varchar(4096)
- requestType — int(11)
- requestTrigger — int(11)
inviteCode
- id — int(11) — Primary key — NOT NULL
- code — varchar(255)
- expiration — datetime
- channelID — int(11) — Foreign key → Channel.id
- uses — int(11)
invitedViewer
- id — int(11) — Primary key — NOT NULL
- userID — int(11) — Foreign key → user.id
- channelID — int(11) — Foreign key → Channel.id
- addedDate — datetime
- expiration — datetime
- inviteCode — int(11) — Foreign key → inviteCode.id
ip_list
- id — int(11) — Primary key — NOT NULL
- ipAddress — varchar(1024)
- reason — varchar(1024)
logs
- id — int(11) — Primary key — NOT NULL
- timestamp — datetime
- message — varchar(1024)
- type — int(11)
menu (Untitled2)
- id — int(11) — Primary key — NOT NULL
- rastaurantId (id2) — int(11) — Foreign key → restaurant.id — NOT NULL
- name (Field)
- price (Field2)
- commant (Field3)
- image (Field4)
o_auth_provider
- id — int(11) — Primary key — NOT NULL
- name — varchar(40)
- friendlyName — varchar(64)
- preset_auth_type — varchar(64)
- displayColor — varchar(8)
- client_id — varchar(256)
- client_secret — varchar(256)
- access_token_url — varchar(1024)
- access_token_params — varchar(1024)
- authorize_url — varchar(1024)
- authorize_params — varchar(1024)
- api_base_url — varchar(1024)
- client_kwargs — varchar(2056)
- profile_endpoint — varchar(2056)
- id_value — varchar(256)
- username_value — varchar(256)
- email_value — varchar(256)
restaurant (Untitled)
- id — int(11) — Primary key — NOT NULL
- name — varchar(255)
- welcomMesssage (welcomMessage) — varchar(255)
- image (imgae) — varchar(255)
- address
- phone (Field)
- cellPhone (Field2)
- businessNumber (Field3)
restreamDestinations
- id — int(11) — Primary key — NOT NULL
- name — varchar(255)
- channel — int(11) — Foreign key → Channel.id
- enabled — tinyint(1)
- url — varchar(4096)
review (Untitled4)
- id (Key) — Primary key — NOT NULL
- id — int(11) — Foreign key → menu.id — NOT NULL
- rastaurantId (id2) — int(11) — Foreign key → menu.rastaurantId — NOT NULL
- clean (Field)
- taste (Field2)
- comment (Field3)
- tip (Field4)
role
- id — int(11) — Primary key — NOT NULL
- name — varchar(80)
- description — varchar(255)
- default — tinyint(1)
roles_users
- id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → user.id
- role_id — int(11) — Foreign key → role.id
rtmpServer
- id — int(11) — Primary key — NOT NULL
- address — varchar(1024)
- active — tinyint(1)
- hide — tinyint(1)
score_streaming (Untitled5)
- id (Key) — Primary key — NOT NULL
- good (Field)
- timestamp (Field3)
- userId (Field4)
settings
- id — int(11) — Primary key — NOT NULL
- siteName — varchar(255)
- siteProtocol — varchar(24)
- siteAddress — varchar(255)
- smtpAddress — varchar(255)
- smtpPort — int(11)
- smtpTLS — tinyint(1)
- smtpSSL — tinyint(1)
- smtpUsername — varchar(255)
- smtpPassword — varchar(255)
- smtpSendAs — varchar(255)
- allowRecording — tinyint(1)
- allowUploads — tinyint(1)
- protectionEnabled — tinyint(1)
- adaptiveStreaming — tinyint(1)
- background — varchar(255)
- showEmptyTables — tinyint(1)
- allowComments — tinyint(1)
- systemTheme — varchar(255)
- systemLogo — varchar(255)
- version — varchar(255)
- sortMainBy — int(11)
- restreamMaxBitrate — int(11)
- serverMessageTitle — varchar(256)
- serverMessage — varchar(8192)
- maxClipLength — int(11)
- proxyFQDN — varchar(2048)
- maintenanceMode — tinyint(1)
- buildEdgeOnRestart — tinyint(1)
- allowRegistration — tinyint(1)
- requireConfirmedEmail — tinyint(1)
stickers
- id — int(11) — Primary key — NOT NULL
- name — varchar(255)
- channelID — int(11) — Foreign key → Channel.id
- filename — varchar(1024)
streamHistory
- id — int(11) — Primary key — NOT NULL
- streamUUID — varchar(255)
- streamerID — int(11)
- streamerName — varchar(255)
- channelID — int(11)
- channelName — varchar(255)
- streamName — varchar(255)
- startTime — datetime
- endTime — datetime
- length — int(11)
- viewers — int(11)
- upvotes — int(11)
- recorded — tinyint(1)
- recordedVideoID — int(11)
- topicID — int(11)
- topicName — varchar(255)
stream_upvotes
- id — int(11) — Primary key — NOT NULL
- userID — int(11)
- streamID — int(11) — Foreign key → Stream.id
topics
- id — int(11) — Primary key — NOT NULL
- name — varchar(255)
- iconClass — varchar(255)
user
- id — int(11) — Primary key — NOT NULL
- uuid — varchar(255)
- username — varchar(255)
- email — varchar(255)
- fs_uniquifier — varchar(255)
- tf_primary_method — varchar(140)
- tf_totp_secret — varchar(255)
- password — varchar(255)
- biography — varchar(4096)
- active — tinyint(1)
- confirmed_at — datetime
- last_login_at — datetime
- current_login_at — datetime
- last_login_ip — varchar(100)
- current_login_ip — varchar(100)
- login_count — int(11)
- pictureLocation — varchar(255)
- authType — int(11)
- oAuthID — varchar(2048)
- oAuthProvider — varchar(40)
- xmppToken — varchar(64)
userNotification
- id — int(11) — Primary key — NOT NULL
- notificationID — varchar(255)
- timestamp — datetime
- message — varchar(1024)
- link — varchar(1024)
- image — varchar(256)
- userID — int(11) — Foreign key → user.id
- read — tinyint(1)
videoComments
- id — int(11) — Primary key — NOT NULL
- userID — int(11) — Foreign key → user.id
- timestamp — datetime
- comment — varchar(2048)
- videoID — int(11) — Foreign key → RecordedVideo.id
video_upvotes
- id — int(11) — Primary key — NOT NULL
- userID — int(11)
- videoID — int(11) — Foreign key → RecordedVideo.id
views
- id — int(11) — Primary key — NOT NULL
- date — datetime
- viewType — int(11)
- itemID — int(11)
webhook
- id — int(11) — Primary key — NOT NULL
- name — varchar(255)
- channelID — int(11) — Foreign key → Channel.id
- endpointURL — varchar(2048)
- requestHeader — varchar(4096)
- requestPayload — varchar(4096)
- requestType — int(11)
- requestTrigger — int(11)