Skip to content

Instantly share code, notes, and snippets.

@ryancutter
Last active January 3, 2016 00:07
Show Gist options
  • Save ryancutter/38c2d4c8d1e184a319ba to your computer and use it in GitHub Desktop.
Save ryancutter/38c2d4c8d1e184a319ba to your computer and use it in GitHub Desktop.
db=# create table object_type (id bigint, parent_id bigint,
label text, location text, direct_location boolean);
db=# select * from object_type;
id | parent_id | label | location | direct_location
-----+-----------+-------------+------------+-----------------
100 | 0 | book | main floor | t
101 | 100 | non-fiction | main floor | f
102 | 101 | history | main floor | f
103 | 102 | ww2 | main floor | t
104 | 101 | biography | 2nd floor | t
105 | 100 | fiction | main floor | f
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment