Post by Zigmister on Jan 31, 2013 1:47:15 GMT -6
Very loose and quick definition, just to keep my work straight. Sorry if this ends up flooding the forum:
This is an excerpt from a NCDA Brand Identity Guidebook that is being put together. Its purpose is to establish a common base of how the NCDA could operate in various mediums. The forum is one of the easiest places to store this running tally. It also gives members the ability to submit input on to what the NCDA is and where it's going, so feel the freedom to comment.
NCDA Policy Guidelines > Member Teams > Membership
Again, quick and dirty for now.
Member Team IDs:
When a Member Team joins the NCDA, it is given an ID. This ensures a unique ID for each club and contributes to consistent record keeping. If a club is inactive or declared defunct, it keeps its ID. Should the Club become active again, it picks up where the Club left off and uses the same ID.
The first five Founding Members are sorted based by when the Club was founded. Each additional team to join the League is ordered from the date they first play in a League match.
List of Member Teams by League join date:
1. DePaul - Founding Member
2. Kent - Founding Member
3. OSU - Founding Member
4. MSU - Founding Member
5. DCC - Founding Member - Defunct
6. GVSU
7. OUMI - Defunct
8. UK
9. K-State
10. BGSU
11. Marshall - Defunct
12. SVSU
13. WKU
14. CMU
15. UWP
16. UofL - Inactive
17. HFCC - Defunct
18. Miami
19. NSU
20. WIU - Inactive
21. EMU - Inactive
22. MAD
23. LCC - Inactive
24. UNL - 2/20/2011
25. UMD - 11/13/2011
26. JMU - 11/13/2011
27. TU - 11/13/2011
28. RIT - 3/31/2012
29. VCU 4/28/2012
30. UNT 3/23/2013
31. PSU 4/12/2013
[Might attach official dates to these, as applicable. There's a team table in the database full of this information.]
Database Information:
TEAMS:
Join ID, Acronym, Name, School, Region, Founded, Joined, Logo, Note
rails generate scaffold Team join_id:integer, acronym:string, name:string, school:string, region:string, founded:date, joined:date, logo:string, note:string
SEASONS
Date, Venue, Event, Winning Team, Losing Team, Winning Team ID, Losing Team ID, Won Points, Lost Points, OT:T/F, Note: Scrim, JV, Exb, F
rails generate scaffold 2012_result: date:date, venue:string, event:string, w_id:integer, l_id:integer, w_pts:integer, l_pts:integer, ot:integer, note:string
This is an excerpt from a NCDA Brand Identity Guidebook that is being put together. Its purpose is to establish a common base of how the NCDA could operate in various mediums. The forum is one of the easiest places to store this running tally. It also gives members the ability to submit input on to what the NCDA is and where it's going, so feel the freedom to comment.
NCDA Policy Guidelines > Member Teams > Membership
Again, quick and dirty for now.
Member Team IDs:
When a Member Team joins the NCDA, it is given an ID. This ensures a unique ID for each club and contributes to consistent record keeping. If a club is inactive or declared defunct, it keeps its ID. Should the Club become active again, it picks up where the Club left off and uses the same ID.
The first five Founding Members are sorted based by when the Club was founded. Each additional team to join the League is ordered from the date they first play in a League match.
List of Member Teams by League join date:
1. DePaul - Founding Member
2. Kent - Founding Member
3. OSU - Founding Member
4. MSU - Founding Member
5. DCC - Founding Member - Defunct
6. GVSU
7. OUMI - Defunct
8. UK
9. K-State
10. BGSU
11. Marshall - Defunct
12. SVSU
13. WKU
14. CMU
15. UWP
16. UofL - Inactive
17. HFCC - Defunct
18. Miami
19. NSU
20. WIU - Inactive
21. EMU - Inactive
22. MAD
23. LCC - Inactive
24. UNL - 2/20/2011
25. UMD - 11/13/2011
26. JMU - 11/13/2011
27. TU - 11/13/2011
28. RIT - 3/31/2012
29. VCU 4/28/2012
30. UNT 3/23/2013
31. PSU 4/12/2013
[Might attach official dates to these, as applicable. There's a team table in the database full of this information.]
Database Information:
TEAMS:
Join ID, Acronym, Name, School, Region, Founded, Joined, Logo, Note
rails generate scaffold Team join_id:integer, acronym:string, name:string, school:string, region:string, founded:date, joined:date, logo:string, note:string
SEASONS
Date, Venue, Event, Winning Team, Losing Team, Winning Team ID, Losing Team ID, Won Points, Lost Points, OT:T/F, Note: Scrim, JV, Exb, F
rails generate scaffold 2012_result: date:date, venue:string, event:string, w_id:integer, l_id:integer, w_pts:integer, l_pts:integer, ot:integer, note:string