Skip to content

Instantly share code, notes, and snippets.

@drob drob/app_schema.txt
Created Jun 22, 2016

Embed
What would you like to do?
Table "public.app"
Column | Type | Modifiers
---------------------------+------------------------+-------------------------------------------------------------------------------
app_id | bigint | not null default nextval('app_app_id_seq'::regclass)
stripe_id | character varying(255) |
discount | character varying(255) |
free_trial_end | bigint | not null default (date_part('epoch'::text, now()) * (1000)::double precision)
name | character varying(255) |
email | character varying(255) |
time | bigint | default (date_part('epoch'::text, now()) * (1000)::double precision)
payment_plan | character varying(255) |
affiliate | character varying(255) |
deactivated | boolean | not null default false
ip_filters | text |
referrer | character varying(255) |
trial_reset | character varying(255) |
block_trial_extension | boolean | not null default false
phone | character varying(255) |
referring_code | character varying(255) |
price | integer |
billdate | integer |
cycle | character varying(255) |
paid_through | bigint |
account_manager | character varying(255) | not null default 'John Clover'::character varying
dedicated_account_manager | boolean | not null default false
force_automated_emails | boolean | not null default false
session_limit | integer |
employee_count_range | character varying(255) |
Indexes:
"app_pkey" PRIMARY KEY, btree (app_id)
"app_email_key" UNIQUE CONSTRAINT, btree (email)
Referenced by:
TABLE "alias" CONSTRAINT "alias_app_id_fkey" FOREIGN KEY (app_id) REFERENCES app(app_id)
TABLE "sent_email" CONSTRAINT "sent_email_app_id_fkey" FOREIGN KEY (app_id) REFERENCES app(app_id)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.