| System: |
 |
Fields
| idActor |
integer |
 |
|
|
|
|
|
|
| strActor |
text |
|
|
|
|
|
|
|
| strThumb |
text |
|
|
|
|
|
|
|
| strIMDB |
text |
|
|
|
|
|
|
|
| strTMDB |
text |
|
|
|
|
|
|
|
Indexes
There are no indexes for table "actors"
Foreign keys
There are no foreign keys for table "actors"
Checks
There are no checks for table "actors"
Triggers
References
There are no references for table "actors"
Definition:
CREATE TABLE actors (
idActor integer PRIMARY KEY AUTOINCREMENT,
strActor text NOT NULL,
strThumb text,
strIMDB text,
strTMDB text
);
CREATE TRIGGER delete_person
AFTER DELETE
ON actors
BEGIN
DELETE FROM art WHERE media_id=old.idActor AND media_type IN ('actor','artist','writer','director');
END;
