| System: |
 |
Fields
| idRating |
integer |
 |
|
|
|
|
|
|
| media_id |
integer |
|
|
|
|
|
|
|
| media_type |
text |
|
|
|
|
|
|
|
| rating_type |
text |
|
|
|
|
|
|
|
| rating_max |
integer |
|
|
|
|
|
|
|
| rating |
float(50) |
|
|
|
|
|
|
|
| votes |
integer |
|
|
|
|
|
|
|
| isDefault |
boolean |
|
|
|
|
|
|
|
Indexes
Foreign keys
There are no foreign keys for table "rating"
Checks
There are no checks for table "rating"
Triggers
There are no triggers for table "rating"
References
There are no references for table "rating"
Definition:
CREATE TABLE rating (
idRating integer PRIMARY KEY AUTOINCREMENT,
media_id integer,
media_type text,
rating_type text,
rating_max integer,
rating float(50),
votes integer,
isDefault boolean
);
CREATE INDEX ix_rating
ON rating
(media_id, media_type);
