Difference between revisions of "Database Schema"
From MythTV Official Wiki
m (User Manual 2f Technical Details Appendix 2f Database Schemata moved to Database Schemata) |
(External links to database homepages) |
||
Line 1: | Line 1: | ||
= Database Table Layouts = | = Database Table Layouts = | ||
− | This section is for the layouts and internal detail of the tables Myth stores in your database engine; either MySQL or (hopefully sometime soon) [ | + | This section is for the layouts and internal detail of the tables Myth stores in your database engine; either [http://www.mysql.com/ MySQL] or (hopefully sometime soon) [http://www.postgresql.org/ PostgreSQL]. |
There will be one page for each table; it will list each field, what it does, it's domain, and what other tables link to it, as well as a paragraph at the top explaining the semantics. Hopefully, the development team will help out on this one; inferring database semantics is a mug's game, at best. Thanks to [[Kevin Kuphal]] for doing the original keying of this stuff, so that all I had to do was copy, paste, and annotate. | There will be one page for each table; it will list each field, what it does, it's domain, and what other tables link to it, as well as a paragraph at the top explaining the semantics. Hopefully, the development team will help out on this one; inferring database semantics is a mug's game, at best. Thanks to [[Kevin Kuphal]] for doing the original keying of this stuff, so that all I had to do was copy, paste, and annotate. |
Revision as of 15:31, 28 February 2006
Database Table Layouts
This section is for the layouts and internal detail of the tables Myth stores in your database engine; either MySQL or (hopefully sometime soon) PostgreSQL.
There will be one page for each table; it will list each field, what it does, it's domain, and what other tables link to it, as well as a paragraph at the top explaining the semantics. Hopefully, the development team will help out on this one; inferring database semantics is a mug's game, at best. Thanks to Kevin Kuphal for doing the original keying of this stuff, so that all I had to do was copy, paste, and annotate.
- callsignnetworkmap
- capturecard
- cardinput
- channel
- codecparams
- conflictresolutionany
- conflictresolutionoverride
- conflictresolutionsingle
- credits
- dvb_channel
- dvb_pids
- dvb_sat
- dvb_signal_quality
- favorites
- housekeeping
- jumppoints
- keybindings
- keyword
- mythlog
- networkiconmap
- oldprogram
- oldrecorded
- people
- profilegroups
- program
- programgenres
- programrating
- recgrouppassword
- record
- recorded
- recordedmarkup
- recordingprofiles
- recordoverride
- settings
- transcoding
- videocategory
- videocountry
- videogenre
- videometadata
- videometadatacountry
- videometadatagenre
- videosource
- videotypes