reentrada/migrations/2022-09-12-174911_create_objects/up.sql

12 lines
336 B
MySQL
Raw Permalink Normal View History

2022-09-12 20:47:35 +02:00
CREATE TABLE object (
tag varchar(100) NOT NULL,
tipo varchar(100) NOT NULL,
2022-09-13 18:50:01 +02:00
nombre varchar(100) NOT NULL,
2022-09-12 20:47:35 +02:00
descripcion varchar(2048) NOT NULL,
2022-09-13 18:50:01 +02:00
location varchar(100) NOT NULL,
peso int NOT NULL,
destino varchar(100),
2022-09-23 22:30:11 +02:00
condiciones text[] NOT NULL default '{}',
2022-09-12 20:47:35 +02:00
CONSTRAINT PK_Object PRIMARY KEY (tag)
)