Column     |          Type          | Collation | Nullable |               Default               | Storage  | Stats target | Description
----------------+------------------------+-----------+----------+-------------------------------------+----------+--------------+-------------
 listing_id     | integer                |           | not null | nextval('listing_id_seq'::regclass) | plain    |              |
 media_type     | character varying(20)  |           |          |                                     | extended |              |
 media_sub_type | character varying(40)  |           |          |                                     | extended |              |
 is_series      | character varying(3)   |           | not null | 'no'::character varying             | extended |              |
 is_update      | character varying(3)   |           | not null | 'no'::character varying             | extended |              |
 author         | character varying(100) |           |          |                                     | extended |              |
 url            | character varying(300) |           |          |                                     | extended |              |
 isbn           | character varying(17)  |           |          |                                     | extended |              |
 name           | character varying(400) |           |          |                                     | extended |              |
Indexes:
    "listing_t_pkey" PRIMARY KEY, btree (listing_id)
    "duplicate_check" UNIQUE CONSTRAINT, btree (media_type, name)
Check constraints:
    "listing_t_is_series_check" CHECK (is_series::text = ANY (ARRAY['no'::character varying, 'yes'::character varying]::text[]))
    "listing_t_is_update_check" CHECK (is_update::text = ANY (ARRAY['no'::character varying, 'yes'::character varying]::text[]))
    "listing_t_isbn_check" CHECK (isbn::text ~ '^[0-9*(-[0-9]+)*$'::text)
    "required_fields" CHECK (num_nonnulls(url, isbn) > 0 OR 2 = num_nonnulls(name, media_sub_type) OR 2 = num_nonnulls(author, media_type))
Foreign-key constraints:
    "media_type_validity" FOREIGN KEY (media_type, media_sub_type) REFERENCES media_sub_types_t(media_type, media_sub_type)
Rules:
    del_sync_tracker AS
    ON DELETE TO listing_t DO  DELETE FROM tracker_t
  WHERE tracker_t.listing_id = old.listing_id
    ins_stamp AS
    ON INSERT TO listing_t DO  INSERT INTO tracker_t (entry_date_added, entry_user_added)
  VALUES ('now'::text::date, "current_user"())
    upd_stamp AS
    ON UPDATE TO listing_t DO  UPDATE tracker_t SET entry_date_modified = 'now'::text::date, entry_time_modified = 'now'::text::time with time zone, entry_user_modified = "current_user"()
  WHERE tracker_t.listing_id = new.listing_id