career_details

Description

Table Definition 
CREATE TABLE `career_details` (
  `career_id` int NOT NULL,
  `row_no` int NOT NULL,
  `subject_ja_jp` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `subject_en_us` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `skills` text COLLATE utf8mb4_bin,
  PRIMARY KEY (`career_id`,`row_no`),
  CONSTRAINT `career_details_ibfk_1` FOREIGN KEY (`career_id`) REFERENCES `careers` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin

Columns

Name Type Default Nullable Children Parents Comment
career_id int false careers
row_no int false
subject_ja_jp varchar(255) false
subject_en_us varchar(255) false
skills text true

Constraints

Name Type Definition
career_details_ibfk_1 FOREIGN KEY FOREIGN KEY (career_id) REFERENCES careers (id)
PRIMARY PRIMARY KEY PRIMARY KEY (career_id, row_no)

Indexes

Name Definition
PRIMARY PRIMARY KEY (career_id, row_no) USING BTREE

Relations

er

Generated by tbls