Skip to content

Project

Luke Cassar edited this page Aug 21, 2018 · 3 revisions

To store all information concerning a TeamProject.

DB Table Schema

Attribute Type
id integer
team_name string
description text
data_story text
source_code_url string
video_url string
homepage_url string

Validations

Attribute Constraint Value
title max length MAX_STRING_LENGTH
description max length MAX_TEXT_LENGTH
data_story max length MAX_TEXT_LENGTH
source_code_url max length MAX_URL_LENGTH
video_url max length MAX_URL_LENGTH
homepage_url max length MAX_URL_LENGTH

Policies

@Cruion Should team_name's be unique?

Associations

  • One Project has only one TeamProject
  • One Project has many thumbnails
    • As an asset in an external storage platform (AWS S3)
  • One Project has many high_res_img
    • As an asset in an external storage platform (AWS S3)

Permissions

Title Create Update Read Destroy
Team Captain
Team Member
(Public User)

Clone this wiki locally