Skip to content

Instantly share code, notes, and snippets.

@zachpendleton

zachpendleton/V1__create_courses_table.sql

Created June 25, 2021 07:49
Show Gist options
  • Save zachpendleton/92daae645e7cd798e3c1142cfbc1c282 to your computer and use it in GitHub Desktop.
Save zachpendleton/92daae645e7cd798e3c1142cfbc1c282 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
V1__create_courses_table.sql
CREATE TABLE courses (
id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
name TEXT NOT NULL,
start_at TIMESTAMPTZ,
visibility TEXT NOT NULL DEFAULT 'VISIBLE',
seats INT NOT NULL DEFAULT 0,
enrollment_active BOOLEAN NOT NULL DEFAULT TRUE,
created_at TIMESTAMPTZ DEFAULT NOW(),
updated_at TIMESTAMPTZ
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment