Skip to content

Instantly share code, notes, and snippets.

@CodebyOmar

CodebyOmar/message_tbl.md

Last active February 4, 2019 11:45
Show Gist options
  • Save CodebyOmar/40682520392b444e757960989eef22b5 to your computer and use it in GitHub Desktop.
Save CodebyOmar/40682520392b444e757960989eef22b5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
message_tbl.md 
message (
  id SERIAL NOT NULL PRIMARY KEY
  "text" TEXT NOT NULL
  username INT FOREIGN KEY REFERENCES user(username) NOT NULL
  room_id INT FOREIGN KEY REFERENCES room(id) NOT NULL
  "timestamp" timestamp with time zone DEFAULT now() NOT NULL
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment