SQL
CREATE TABLE `unitLocalization` (
`id` text PRIMARY KEY,
`unit_id` text NOT NULL,
`name_de` text,
`name_en` text,
`name_fr` text,
`name_it` text,
`name_ru` text,
`name_ua` text,
`name_ar` text,
`name_cs` text,
`name_es` text,
`name_hr` text,
`name_hu` text,
`name_pl` text,
`name_pt` text,
`description_de` text,
`description_en` text,
`description_fr` text,
`description_it` text,
`description_ru` text,
`description_ua` text,
`description_ar` text,
`description_cs` text,
`description_es` text,
`description_hr` text,
`description_hu` text,
`description_pl` text,
`description_pt` text,
CONSTRAINT `fk_unitLocalization_unit_id_unit_id_fk` FOREIGN KEY (`unit_id`) REFERENCES `unit`(`id`)
)
Columns
| Column | Data type | Allow null | Primary key | Actions |
|---|---|---|---|---|
id |
TEXT |
✓ | ✓ | Rename | Drop |
unit_id |
TEXT |
Rename | Drop | ||
name_de |
TEXT |
✓ | Rename | Drop | |
name_en |
TEXT |
✓ | Rename | Drop | |
name_fr |
TEXT |
✓ | Rename | Drop | |
name_it |
TEXT |
✓ | Rename | Drop | |
name_ru |
TEXT |
✓ | Rename | Drop | |
name_ua |
TEXT |
✓ | Rename | Drop | |
name_ar |
TEXT |
✓ | Rename | Drop | |
name_cs |
TEXT |
✓ | Rename | Drop | |
name_es |
TEXT |
✓ | Rename | Drop | |
name_hr |
TEXT |
✓ | Rename | Drop | |
name_hu |
TEXT |
✓ | Rename | Drop | |
name_pl |
TEXT |
✓ | Rename | Drop | |
name_pt |
TEXT |
✓ | Rename | Drop | |
description_de |
TEXT |
✓ | Rename | Drop | |
description_en |
TEXT |
✓ | Rename | Drop | |
description_fr |
TEXT |
✓ | Rename | Drop | |
description_it |
TEXT |
✓ | Rename | Drop | |
description_ru |
TEXT |
✓ | Rename | Drop | |
description_ua |
TEXT |
✓ | Rename | Drop | |
description_ar |
TEXT |
✓ | Rename | Drop | |
description_cs |
TEXT |
✓ | Rename | Drop | |
description_es |
TEXT |
✓ | Rename | Drop | |
description_hr |
TEXT |
✓ | Rename | Drop | |
description_hu |
TEXT |
✓ | Rename | Drop | |
description_pl |
TEXT |
✓ | Rename | Drop | |
description_pt |
TEXT |
✓ | Rename | Drop |
Foreign Keys
| Column | Destination |
|---|---|
unit_id |
unit.id |
Indexes
| Name | Columns | Unique | SQL | Drop? |
|---|---|---|---|---|
| sqlite_autoindex_unitLocalization_1 |
id
|
✓ | SQL | Drop |