Search code examples
mysqlsqllocalizationdatabase-normalization

Table localization - One column for a table

I have got only one column for a table when i create two localized tables. Code as bellow.

-- Month
CREATE TABLE `month` (
  `id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
);

-- Month Localized
CREATE TABLE `month_loc` (
  `month_id'    INT NOT NULL,
  `name`        VARCHAR(200)    NOT NULL,
  `description` VARCHAR(500)    NOT NULL,
  `lang_id`     INT NOT NULL
);

month_loc.month_id is the foreign key.

month table holds only the primary key. Other all fields should be localized. Is this table structure correct ?

Thanks.

Solution

  • If correct implies a certain degree of normalization, and the content of your columns name and description vary per month_id, lang_id (which would be the combined primary key of month_loc), then yes, your design has reached the 3rd grade of normlization.