Skip to content

Instantly share code, notes, and snippets.

@danypr92
Created April 19, 2018 11:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save danypr92/17acb3bf0b7803813ad74460afcf065f to your computer and use it in GitHub Desktop.
Save danypr92/17acb3bf0b7803813ad74460afcf065f to your computer and use it in GitHub Desktop.
Product Template
                                                                       Table "public.product_template"
         Column         |              Type              |                           Modifiers                           | Storage  | Stats target |       Description       
------------------------+--------------------------------+---------------------------------------------------------------+----------+--------------+-------------------------
 id                     | integer                        | not null default nextval('product_template_id_seq'::regclass) | plain    |              | 
 category               | integer                        |                                                               | plain    |              | Category
 create_uid             | integer                        |                                                               | plain    |              | Create User
 create_date            | timestamp(6) without time zone |                                                               | plain    |              | Create Date
 name                   | character varying              | not null                                                      | extended |              | Name
 write_uid              | integer                        |                                                               | plain    |              | Write User
 default_uom            | integer                        | not null                                                      | plain    |              | Default UOM
 write_date             | timestamp(6) without time zone |                                                               | plain    |              | Write Date
 active                 | boolean                        | default false                                                 | plain    |              | Active
 consumable             | boolean                        | default false                                                 | plain    |              | Consumable
 type                   | character varying              | not null                                                      | extended |              | Type
 taxes_category         | boolean                        | default false                                                 | plain    |              | Use Category's Taxes
 account_category       | boolean                        | default false                                                 | plain    |              | Use Category's accounts
 internet_adsl          | boolean                        | default false                                                 | plain    |              | Internet ADSL
 internet_phone_minutes | integer                        |                                                               | plain    |              | Internet Phone Minutes
 mobile_minutes         | integer                        |                                                               | plain    |              | Mobile Minutes
 service_type           | character varying              |                                                               | extended |              | Service Type
 internet_fibre         | boolean                        | default false                                                 | plain    |              | Internet Fibre
 internet_speed         | integer                        |                                                               | plain    |              | Internet Speed
 mobile_internet        | integer                        |                                                               | plain    |              | Mobile Internet
 mobile_unlimited       | integer                        |                                                               | plain    |              | Mobile Unlimited
 internet_phone         | boolean                        | default false                                                 | plain    |              | Internet Phone

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment