Changes between Version 3 and Version 4 of database

Show
Ignore:
Author:
anonymous (IP: 83.93.102.110)
Timestamp:
11/20/07 05:44:25 (2 years ago)
Comment:

fixed garbled up flow

Legend:

Unmodified
Added
Removed
Modified
  • database

    v3 v4  
    3320:13 <ryan> one place i think we could start is to take the sf-active database schema 
    4420:13 <ryan> make improvements to it 
    5 20:13 <ryan> and just start getting a cak project going 
    6 20:13 <yossarian> sounds good 
    7 20:13 <yossarian> i assume that sf-active has like a flat inheritance hierarchy, though? 
    8 20:13 <ryan> i mean, we might end up with radically different sql 
    9 20:13 <yossarian> personally i was thinking we might want to have a database with inheritance, so we don't have a table for articles, a table for events, a  
    10                   table for XXXX 
    11 20:13 <yossarian> instead have one content table 
    12 20:14 <yossarian> with a "type" column 
    13 20:14 <ryan> interesting... if we can figure that out, lets put that change into the sfa swl 
    14 20:14 <yossarian> and do like class Article extends Content 
    15 20:14 <ryan> that we'll start with 
    16 20:14 <yossarian> and then just re-use the Content table 
    17 20:14 <ryan> you mean in the code? 
    18 20:14 <yossarian> yeah 
    19 20:14 <yossarian> are you familiar with single-table inheritance as it relates to object-relational mapping? 
    20 20:14 <ryan> yeah hm. 
    21 20:14 <ryan> no, i'm not  
    22 20:14 <yossarian> ok 
    23 20:14 <ryan> url, or tell me? 
    24 20:14 <yossarian> let me do a short explanation  
    25 20:14 <yossarian> basically 
    26 20:14 <yossarian> forget about the db for the moment 
    27 20:14 <yossarian> any app with a decent sized domain model  
    28 20:14 <yossarian> generally benefits from inheritance in its model classes 
    29 20:14 <yossarian> so if you look here: http://dev.bunke.indymedia.org/wiki/DomainModel 
    30520:13 <ryan> and just start getting a cak project going 
    31620:13 <yossarian> sounds good