markets

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
market_id bigserial 19 nextval('markets_market_id_seq'::regclass)
publication_format_id int8 19 null
publication_formats.publication_format_id markets_publication_format_idC
countries_included text 2147483647 null
countries_excluded text 2147483647 null
regions_included text 2147483647 null
regions_excluded text 2147483647 null
market_date_role varchar 40 null
market_date_format varchar 40 null
market_date varchar 255 null
price varchar 255 null
discount varchar 255 null
price_type_code varchar 255 null
currency_code varchar 255 null
tax_rate_code varchar 255 null
tax_type_code varchar 255 null
agent_id int8 19 null
supplier_id int8 19 null

Indexes

Constraint Name Type Sort Column(s)
markets_pkey Primary key Asc market_id
format_markets_pkey Performance Asc/Asc market_id + publication_format_id
markets_publication_format_id Performance Asc publication_format_id

Relationships