You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
14 lines
394 B
14 lines
394 B
create table if not exists camera_remark
|
|
(
|
|
id serial not null,
|
|
camera_id integer not null,
|
|
remark varchar(256) not null,
|
|
constraint camera_remark_pk
|
|
primary key (id),
|
|
constraint camera_remark_camera_id_fk
|
|
foreign key (camera_id) references camera
|
|
);
|
|
|
|
create unique index if not exists camera_remark_id_uindex
|
|
on camera_remark (id);
|
|
|
|
|