Skip to content

Instantly share code, notes, and snippets.

@badri
Created February 14, 2016 03:05
Show Gist options
  • Save badri/09ddad9e16276fca32b0 to your computer and use it in GitHub Desktop.
Save badri/09ddad9e16276fca32b0 to your computer and use it in GitHub Desktop.
Table schema
CREATE TABLE genres (
id serial NOT NULL PRIMARY KEY,
name character varying(255) NOT NULL,
parent_id integer REFERENCES genres (id)
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment