public.actor
Description
Columns
Name | Type | Default | Nullable | Children | Parents | Comment |
---|---|---|---|---|---|---|
actor_id | integer | nextval('actor_actor_id_seq'::regclass) | false | public.film_actor | ||
first_name | text | false | ||||
last_name | text | false | ||||
last_update | timestamp with time zone | now() | false |
Constraints
Name | Type | Definition |
---|---|---|
actor_pkey | PRIMARY KEY | PRIMARY KEY (actor_id) |
Indexes
Name | Definition |
---|---|
actor_pkey | CREATE UNIQUE INDEX actor_pkey ON public.actor USING btree (actor_id) |
idx_actor_last_name | CREATE INDEX idx_actor_last_name ON public.actor USING btree (last_name) |
Triggers
Name | Definition |
---|---|
last_updated | CREATE TRIGGER last_updated BEFORE UPDATE ON public.actor FOR EACH ROW EXECUTE FUNCTION last_updated() |