hausys
Tables (3)
product
- id — INT — Primary key — NOT NULL — PK
- id (id2) — int — Foreign key → space.id — NOT NULL — PK
- shop_id — SMALLINT — Foreign key → space.shop_id — NOT NULL — FK
- name — VARCHAR(30) — NOT NULL
shop
- id — SMALLINT — Primary key — NOT NULL — PK
- name — VARCHAR(30) — NOT NULL
space
- id — int — Primary key — NOT NULL — PK
- shop_id — SMALLINT — Foreign key → shop.id — NOT NULL — FK
- name — VARCHAR(30) — NOT NULL