Created
June 22, 2016 02:14
-
-
Save drob/58917b2e9a267cbe0f6217e27b120a74 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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