[sql] exercise

Viewer

copydownloadembedprintName: exercise
  1. CREATE TABLE `contact` (
  2.         `email` CHAR,
  3.         `property_chat_interest` INT,
  4.         PRIMARY KEY (`email`)
  5. );
  6.  
  7. CREATE TABLE `conversation` (
  8.         `id` INT,
  9.         `email` CHAR,
  10.         'created_at' TIMESTAMP
  11.         PRIMARY KEY (`id`)
  12. );
  13.  
  14. CREATE TABLE `conversation-tag` (
  15.         `conversation_id` INT,
  16.         `tag` CHAR,
  17.         PRIMARY KEY (`conversation_id`)
  18. );

Editor

You can edit this paste and save as new:


File Description
  • exercise
  • Paste Code
  • 21 Sep-2018
  • 325 Bytes
You can Share it: