Macaw-Movies/Development/Database schema: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
= List of the tables = | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 68: | Line 65: | ||
|-} | |-} | ||
== movies == | |||
Contains the informations of each movie. | |||
== peoples == | == peoples == | ||
Revision as of 14:33, 23 April 2015
List of the tables
movies
Contains the informations of each movie.
peoples
| Column Name | Type | Foreign key |
|---|---|---|
| id | INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE | id_movie |
| title | VARCHAR(255) NOT NULL | |
| original_title | VARCHAR(255) | |
| release_date | VARCHAR(10) | |
| country | VARCHAR(50) | |
| duration | INTEGER | |
| synopsis | TEXT | |
| file_path | VARCHAR(255) UNIQUE NOT NULL | |
| poster_path | VARCHAR(255) | |
| colored | BOOLEAN | |
| format | VARCHAR(10) | |
| suffix | VARCHAR(10) | |
| rank | INTEGER | |
| imported | BOOLEAN |
movies_people
Bind people to movies, here is defined the type of people (director, actor, ...)
| Column Name | Type | Foreign key |
|---|---|---|
| id | INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE | id_people |
| name | VARCHAR(200) NOT NULL | |
| birthday | VARCHAR(10) | |
| biography | TEXT |
tags
| Column Name | Type | Foreign key |
|---|---|---|
| id | INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE | |
| id_movie | INTEGER NOT NULL | id_movie |
| id_people | INTEGER NOT NULL | id_people |
| type | INTEGER NOT NULL | |
| UNIQUE (id_people, id_movie, type) ON CONFLICT IGNORE | ||
| FOREIGN KEY(id_movie) REFERENCES movies ON DELETE CASCADE | ||
| FOREIGN KEY(id_people) REFERENCES people ON DELETE CASCADE | ||
movies_tags
| Column Name | Type | Foreign key |
|---|---|---|
| id | INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE | id_tag |
| name | VARCHAR(255) UNIQUE NOT NULL |
playlists
| Column Name | Type | Foreign key |
|---|---|---|
| id | INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE | |
| id_movie | INTEGER NOT NULL | id_movie |
| id_tag | INTEGER NOT NULL | id_tag |
| UNIQUE (id_tag, id_movie) ON CONFLICT IGNORE | ||
| FOREIGN KEY(id_movie) REFERENCES movies ON DELETE CASCADE | ||
| FOREIGN KEY(id_tag) REFERENCES tags ON DELETE CASCADE | ||
movies_playlists
| Column Name | Type | Foreign key |
|---|---|---|
| id | INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE | id_playlist |
| name | VARCHAR(255) UNIQUE NOT NULL | |
| rate | INTEGER | |
| creation_date | INT |
paths_list
The paths where to look for movies files
| Column Name | Type | Foreign key |
|---|---|---|
| id | INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE | |
| id_movie | INTEGER NOT NULL | id_movie |
| id_playlist | INTEGER NOT NULL | id_playlist |
| UNIQUE (id_playlist, id_movie) ON CONFLICT IGNORE | ||
| FOREIGN KEY(id_movie) REFERENCES movies ON DELETE CASCADE | ||
| FOREIGN KEY(id_playlist) REFERENCES playlists ON DELETE CASCADE" | ||
config
This table is here for updates purpose.
| Column Name | Type | Foreign key |
|---|---|---|
| id | INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE | |
| movies_path | VARCHAR(255) UNIQUE | |
| imported | BOOLEAN DEFAULT 0 |
| Column Name | Type | Foreign key |
|---|---|---|
| db_version | INTERGER |