Skip to content

accounts.merchants

Description

Columns

Name Type Default Nullable Children Parents Comment
merchant_id integer nextval('merchants_merchant_id_seq'::regclass) false
account_id integer false accounts.accounts
phone varchar(255) false
name varchar(255) false
created_at timestamp with time zone now() true
updated_at timestamp with time zone now() true

Constraints

Name Type Definition
merchants_account_id_fkey FOREIGN KEY FOREIGN KEY (account_id) REFERENCES accounts(account_id)
merchants_pkey PRIMARY KEY PRIMARY KEY (merchant_id)

Indexes

Name Definition
merchants_pkey CREATE UNIQUE INDEX merchants_pkey ON accounts.merchants USING btree (merchant_id)
idx_merchants_account_id CREATE UNIQUE INDEX idx_merchants_account_id ON accounts.merchants USING btree (account_id)
idx_merchants_phone CREATE INDEX idx_merchants_phone ON accounts.merchants USING btree (phone)

Relations

er

Generated by tbls