[sql] d
Viewer
- CREATE DATABASE IF NOT EXISTS marvel CHARACTER SET utf8 COLLATE utf8_general_ci;
- USE marvel;
- CREATE TABLE hero(
- id_hero INTEGER NOT NULL,
- name_hero VARCHAR(30) CHARSET utf8mb4,
- PRIMARY KEY(id_hero)
- ) DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
- CREATE TABLE comic(
- id_comic INTEGER NOT NULL,
- name_comic VARCHAR(80) CHARSET utf8mb4,
- name_writer VARCHAR(20) CHARSET utf8mb4,
- name_editor VARCHAR(20) CHARSET utf8mb4,
- name_colorist VARCHAR(20) CHARSET utf8mb4,
- id_hero INTEGER,
- last_sync datetime,
- PRIMARY KEY(id_comic),
- FOREIGN KEY(id_hero) REFERENCES hero(id_hero)
- ) DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
- CREATE TABLE interaction(
- id_comic INTEGER NOT NULL,
- id_hero_interaction INTEGER NOT NULL,
- PRIMARY KEY(id_comic, id_hero_interaction),
- FOREIGN KEY(id_comic) REFERENCES comic(id_comic),
- FOREIGN KEY(id_hero) REFERENCES hero(id_hero)
- );
Editor
You can edit this paste and save as new:
File Description
- d
- Paste Code
- 27 Feb-2021
- 890 Bytes
You can Share it: