SageTV Community  

Go Back   SageTV Community > SageTV Development and Customizations > SageTV Github Development

Notices

SageTV Github Development Discussion related to SageTV Open Source Development. Use this forum for development topics about the Open Source versions of SageTV, hosted on Github.

Reply
 
Thread Tools Search this Thread Display Modes
  #41  
Old 11-09-2018, 02:14 PM
wnjj wnjj is offline
Sage Icon
 
Join Date: Jan 2009
Posts: 1,035
I never did get around to adding "REFERENCES" statements which would help tremendously in connecting the tables to each other. Many are self-explanatory and the tables called x_by_y are sorted indices to other tables.
Reply With Quote
  #42  
Old 11-09-2018, 02:22 PM
stuckless's Avatar
stuckless stuckless is online now
SageTVaholic
 
Join Date: Oct 2007
Location: London, Ontario, Canada
Posts: 9,539
Quote:
Originally Posted by wnjj View Post
I never did get around to adding "REFERENCES" statements which would help tremendously in connecting the tables to each other. Many are self-explanatory and the tables called x_by_y are sorted indices to other tables.
That is cool, thanks. I didn't realize there were that many tables thx.
Reply With Quote
  #43  
Old 11-09-2018, 02:50 PM
wnjj wnjj is offline
Sage Icon
 
Join Date: Jan 2009
Posts: 1,035
Quote:
Originally Posted by stuckless View Post
That is cool, thanks. I didn't realize there were that many tables thx.
There are less "main" tables than it may seem. Any with an underscore in the name are embedded subtables (i.e. they were just serialized inline with a count and objects following). Basically non-normalized data with 'many' objects associated with 'one'. Those got put into distinct tables for proper DB form. For example, 'show_person' contains a personID and role but those were just stored in the show table in wiz.db. Look at Show.java's DataInput constructor to see this.

Also, there's at least one table (primeTitle) that was only used in prior revisions but my schema dumper doesn't discriminate.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Plugin: DVB-S Importer routerunner Customization Announcements 18 04-11-2019 12:04 PM
Plugin: DVB4Sage EPG Importer Jabroni SageTV v7 Customizations 9 09-14-2014 03:26 AM
XMLTV importer Vaughan SageTV Australia/New Zealand 2 09-22-2010 06:22 AM
er... how do i run the xmltv importer sfag SageTV United Kingdom 4 01-20-2009 07:14 AM
So what importer are most using? wilsonj SageTV Australia/New Zealand 3 02-15-2007 05:34 AM


All times are GMT -6. The time now is 11:11 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Copyright 2003-2005 SageTV, LLC. All rights reserved.