Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

convert most ENUM types into Tables #3

Open
andrewharvey opened this issue Jun 17, 2012 · 1 comment
Open

convert most ENUM types into Tables #3

andrewharvey opened this issue Jun 17, 2012 · 1 comment

Comments

@andrewharvey
Copy link
Owner

Most/all of the ENUM types in 01-create-datatypes.sql should be converted to tables in the same way as census_2011.religious_affiliation is done. This means the long name can exceed 63 characters, and our data tables still only need to reference on a 2 byte smallserial.

It also allows us to attach extra information to each of the, previously ENUM values, such as their Census Dictionary/ABS Classification code.

@ghost ghost assigned andrewharvey Jun 30, 2012
@andrewharvey
Copy link
Owner Author

made some progress recently. only a couple of tricky ones are left.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant