Jump to content

Macaw-Movies/Development/Database schema: Difference between revisions

From KDE Community Wiki
← Older editNewer edit →
Ochurlaud (talk | contribs)
KDEDevelopers, Bots, trusted, webadmin
646 edits
No edit summary
Ochurlaud (talk | contribs)
KDEDevelopers, Bots, trusted, webadmin
646 edits
No edit summary
Line 1: Line 1:


= List of the tables =
= List of the tables =
== movies ==
Contains the informations of each movie.


{| class="wikitable"
{| class="wikitable"
Line 63: Line 68:
| BOOLEAN
| BOOLEAN
|
|
|-}
|}
 
== movies ==
 
Contains the informations of each movie.


== peoples ==
== peoples ==
Line 92: Line 93:
| TEXT
| TEXT
|
|
|-}
|}


== movies_people ==
== movies_people ==
Line 125: Line 126:
|-
|-
| colspan=3 | FOREIGN KEY(id_people) REFERENCES people ON DELETE CASCADE
| colspan=3 | FOREIGN KEY(id_people) REFERENCES people ON DELETE CASCADE
|-}
|}




Line 142: Line 143:
| VARCHAR(255) UNIQUE NOT NULL
| VARCHAR(255) UNIQUE NOT NULL
|
|
|-}
|}


== movies_tags ==
== movies_tags ==
Line 168: Line 169:
|-
|-
| colspan=3 | FOREIGN KEY(id_tag) REFERENCES tags ON DELETE CASCADE
| colspan=3 | FOREIGN KEY(id_tag) REFERENCES tags ON DELETE CASCADE
|-}
|}


== playlists ==
== playlists ==
Line 192: Line 193:
| INT
| INT
|
|
|-}
|}


== movies_playlists ==
== movies_playlists ==
Line 218: Line 219:
|-
|-
| colspan=3 | FOREIGN KEY(id_playlist) REFERENCES playlists ON DELETE CASCADE"
| colspan=3 | FOREIGN KEY(id_playlist) REFERENCES playlists ON DELETE CASCADE"
|-}
|}


== paths_list ==
== paths_list ==
Line 241: Line 242:
| BOOLEAN DEFAULT 0
| BOOLEAN DEFAULT 0
|
|
|-}
|}


== config ==
== config ==


This table is here for updates purpose.
This table is here for update purposes.


{| class="wikitable"
{| class="wikitable"
Line 256: Line 257:
| INTERGER
| INTERGER
|
|
|-}
|}

Revision as of 14:34, 23 April 2015

List of the tables

movies

Contains the informations of each movie.


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

peoples

Column Name Type Foreign key
id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE id_people
name VARCHAR(200) NOT NULL
birthday VARCHAR(10)
biography TEXT

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_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


tags

Column Name Type Foreign key
id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE id_tag
name VARCHAR(255) UNIQUE NOT NULL

movies_tags

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

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

movies_playlists

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"

paths_list

The paths where to look for movies files

Column Name Type Foreign key
id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE
movies_path VARCHAR(255) UNIQUE
imported BOOLEAN DEFAULT 0

config

This table is here for update purposes.

Column Name Type Foreign key
db_version INTERGER
Retrieved from "https://community.kde.org/index.php?title=Macaw-Movies/Development/Database_schema&oldid=42256"