uranux_desenv [uranux.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

sto_gtin

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK	Unique
	gtin_cd	VarChar(13)				GTIN Code
	gtin_nm	VarChar(255)				GTIN Name
	gpc_s_nm	VarChar(100)				Segmentation (GPC)
	gpc_s_cd	VarChar(8)				GPC Segmentation Code
	gpc_b_cd	VarChar(8)				GPC Brick Code
	gpc_c_cd	VarChar(8)				GPC Class Code
	gpc_f_cd	VarChar(8)				GPC Family Code
	gtin_img	VarChar(100)				GTIN Image
	brand_bsin	VarChar(6)				Brand Code
	brand_nm	VarChar(50)				Brand
	brand_img	VarChar(100)				Brand Image
	brand_link	VarChar(100)				Brand Link
	owner_nm	VarChar(50)				Brand Owner
	owner_cd	VarChar(6)				Brand Owner Code
	owner_link	VarChar(50)				Brand Owner Link
	owner_wiki_en	VarChar(100)				Brand Owner Wikipedia Link
	owner_img	VarChar(100)				Brand Owner Image
	gcp_cd	VarChar(12)				GCP Code
	gln_cd	VarChar(13)				GLN Code
	gln_nm	VarChar(150)				Logistical Owner (GLN)
	gln_country_iso_cd	VarChar(2)				GLN Country ISO Code
	gln_addr_city	VarChar(50)				GLN City
	gln_addr_postalcode	VarChar(50)				GLN Postal Code
	gln_addr_02	VarChar(40)				GLN Address2
	gln_addr_03	VarChar(40)				GLN Address3
	gln_addr_04	VarChar(40)				GLN Address4
	gln_last_change	Date				GLN Last Change
	return_code	VarChar(3)				GLN Return Code
	pkg_unit	Integer				Number of Units
	pkg_type_cd	VarChar(2)				Package Type Code
	pkg_type_nm	VarChar(50)				Package Type Name
	m_g	Numeric(10, 1)				Weight (g)
	m_oz	Numeric(10, 1)				Weight (oz)
	m_ml	Numeric(10, 1)				Volume (ml)
	m_floz	Numeric(10, 1)				Volume (fl oz)
	m_abv	Numeric(10, 1)				Alcohol by Volume
	m_abw	Numeric(10, 1)				Alcohol by Weight
	prefix_nm	VarChar(50)				Registration
	country_iso_cd	VarChar(2)				Registration Country ISO Code

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_sto_gtin_bsin	URX_GTIN.sto_brand	URX_GTIN.sto_gtin	bra_bsin	brand_bsin
fk_sto_gtin_gcp	URX_GTIN.sto_gs1_gcp	URX_GTIN.sto_gtin	gcp_cd	gcp_cd

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_sto_gtin_ncm_gtin	URX_GTIN.sto_gtin	URX_GTIN.sto_gtin_ncm	gtin_cd	gtin_ncm_gtin_cd

Triggers (none)

Used in Diagrams (none)