Navigation¶

• Main Page
  

• Random Page
• Create a new Page
• All Pages
• Categories
• Navigation Paths
  

• Administration
• File Management
  

• Create Account
  

Filter by Category

Production Product (table) — 50.0%

[...] manufacture the product. ProductLine nchar(2) null R = Road, M = Mountain, T = Touring, S = Standard Class nchar(2) null H = High, M = Medium, L = Low Style nchar(2) null W = Womens, M = Mens, U = Universal ProductSubcategoryID int null Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID. ProductModelID int null Product is a member of this product model. Foreign key to ProductModel.ProductModelID. SellStartDate datetime not null Date the product was available for sale. SellEndDate datetime null Date [...]

SH CHANNELS (table) — 15.4%

[...] primary key column CHANNEL_DESC VARCHAR2(20) not null e.g. telesales, internet, catalog CHANNEL_CLASS VARCHAR2(20) not null e.g. direct, indirect CHANNEL_CLASS_ID NUMBER not null CHANNEL_TOTAL VARCHAR2(13) not null CHANNEL_TOTAL_ID NUMBER not null Primary Key Primary Key Columns CHANNELS_PK CHANNEL_ID Check Constraints Check Constraint Expression Description SYS_C005145 "CHANNEL_ID" IS NOT NULL SYS_C005146 "CHANNEL_DESC" IS NOT NULL [...]

SH PRODUCTS (table) — 11.5%

[...] not null PROD_CATEGORY_DESC VARCHAR2(2000) not null product category description PROD_WEIGHT_CLASS NUMBER(3, 0) not null product weight class PROD_UNIT_OF_MEASURE VARCHAR2(20) null product unit of measure PROD_PACK_SIZE VARCHAR2(30) not null product package size SUPPLIER_ID NUMBER(6, 0) not null this column PROD_STATUS VARCHAR2(20) not null product status PROD_LIST_PRICE NUMBER(8, 2) not null product list price PROD_MIN_PRICE NUMBER(8, 2) not null product minimum price PROD_TOTAL VARCHAR2(13) not null PROD_TOTAL_ID [...]

OE PRODUCTS (view) — 3.8%

[...] ELSE TRANSLATE(i.product_description USING NCHAR_CS) END AS product_description , i.weight_class , i.warranty_period , i.supplier_id , [...]

WikiMarkup — 3.8%

[...] EmailPromotion BOMLevel ComponentID PerAssemblyQty ProductAssemblyID Status Availability CostRate Class DaysToManufacture ListPrice ProductLine [...]

OE OC_PRODUCT_INFORMATION (view) — 3.8%

[...] OE.OC_PRODUCT_INFORMATION AS SELECT p.product_id, p.product_name, p.product_description, p.category_id, p.weight_class, p.warranty_period, p.supplier_id, p.product_status, [...]

public qrtz_job_details (table) — 3.8%

[...] job_name varchar(80) not null job_group varchar(80) not null description varchar(120) null job_class_name varchar(128) not null is_durable [...]

OE PRODUCT_INFORMATION_TYP (type) — 3.8%

[...] VARCHAR2(50) , product_description VARCHAR2(2000) , category_id NUMBER(2) , weight_class NUMBER(1) , warranty_period INTERVAL [...]

OE PRODUCT_INFORMATION (table) — 3.8%

[...] translated_description in CATEGORY_ID NUMBER(2, 0) null Low cardinality column, can be used for bitmap index. WEIGHT_CLASS NUMBER(1, 0) null Low cardinality column, [...]