Skip to content

Instantly share code, notes, and snippets.

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