Experimental radio CMS based on Flask (Python) micro-framework for Radio Rhino (Strasbourg).
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

TABLES.rst 3.8KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202
  1. ==================
  2. RADIO RHINO TABLES
  3. ==================
  4. list postgresql tables
  5. ----------------------
  6. ----------
  7. blog_posts
  8. ----------
  9. ============ ============
  10. field type
  11. ============ ============
  12. **id** integer
  13. name varchar(256)
  14. description text
  15. timestamp timestamp
  16. *channel_id* integer
  17. ============ ============
  18. **External relationships**
  19. - relation n->n between blog_posts and collectives
  20. - relation n->n between blog_posts and contributors
  21. --------
  22. channels
  23. --------
  24. =========== ============
  25. field type
  26. =========== ============
  27. **id** integer
  28. name varchar(128)
  29. description text
  30. license varchar(256)
  31. mood varchar(128)
  32. music bool
  33. night bool
  34. =========== ============
  35. **External relationships**
  36. - relation 1->n between channels and blog_posts (a blog_post can have only one channel)
  37. - relation n->n between channels and collectives
  38. - relation n->n between channels and contributors
  39. - relation 1->n between channels and events
  40. - relation 1->n between channels and pages
  41. - relation 1->n between channels and podcasts
  42. - relation 1->n between channels and sections
  43. - relation 1->n between channels and tags
  44. ----------------
  45. channels_authors
  46. ----------------
  47. --------------------
  48. channels_collectives
  49. --------------------
  50. ---------------------
  51. channels_contributors
  52. ---------------------
  53. -----------
  54. collectives
  55. -----------
  56. =========== ============
  57. field type
  58. =========== ============
  59. **id** integer
  60. name varchar(128)
  61. description text
  62. email varchar(256)
  63. website varchar(256)
  64. =========== ============
  65. ------------------------
  66. collectives_contributors
  67. ------------------------
  68. ------------
  69. contributors
  70. ------------
  71. =========== ============
  72. field type
  73. =========== ============
  74. **id** integer
  75. name varchar(128)
  76. status varchar(128)
  77. description text
  78. email varchar(256)
  79. website varchar(256)
  80. =========== ============
  81. ------
  82. events
  83. ------
  84. ================ ============
  85. field type
  86. ================ ============
  87. **id** integer
  88. name varchar(128)
  89. description text
  90. place varchar(128)
  91. begin timestamp
  92. end timestamp
  93. *channel_id* integer
  94. *collective__id* integer
  95. *podcast_id* integer
  96. live_show bool
  97. ================ ============
  98. -----
  99. pages
  100. -----
  101. ============ ============
  102. field type
  103. ============ ============
  104. **id** integer
  105. name varchar(128)
  106. description text
  107. *channel_id* integer
  108. ============ ============
  109. --------
  110. podcasts
  111. --------
  112. ============ ============
  113. field type
  114. ============ ============
  115. **id** integer
  116. name varchar(128)
  117. description text
  118. date date
  119. timestamp timestamp
  120. *channel_id* integer
  121. link varchar(256)
  122. license varchar(256)
  123. mood varchar(128)
  124. music bool
  125. night bool
  126. ============ ============
  127. ----------------
  128. podcasts_authors
  129. ----------------
  130. --------------------
  131. podcasts_collectives
  132. --------------------
  133. ---------------------
  134. podcasts_contributors
  135. ---------------------
  136. --------
  137. sections
  138. --------
  139. ============ ============
  140. field type
  141. ============ ============
  142. **id** integer
  143. name varchar(128)
  144. description text
  145. timestamp timestamp
  146. begin time
  147. end time
  148. *channel_id* integer
  149. *podcast_id* integer
  150. mood varchar(128)
  151. ============ ============
  152. ----------------
  153. sections_authors
  154. ----------------
  155. --------------------
  156. sections_collectives
  157. --------------------
  158. ---------------------
  159. sections_contributors
  160. ---------------------
  161. ----
  162. tags
  163. ----
  164. ================ ============
  165. field type
  166. ================ ============
  167. **id** integer
  168. name varchar(129)
  169. *channel_id* integer
  170. *collective__id* integer
  171. *podcast_id* integer
  172. *section_id* integer
  173. ================ ============