Description
contains marketing information for the sporting goods company
Table properties
| name | value |
|---|
| name | GROUPO.MarketingInformation |
| row count | 10 |
| Maximum size of a single row | 32,775 bytes |
Columns
| column | datatype | length | default | nulls | PK | FK | UQ | comment |
|---|
| ID | integer | 4 | | no
| yes
| |
| |
| ProductID | integer | 4 | | no
|
| Products.ID
|
| |
| Description | long varchar | 32767 | | yes
|
| |
| |
References
Foreign key graph
Foreign keys
| name | columns | foreign columns | type | comment |
|---|
| FK_MarketInfoID_ID | ProductID | Products.ID |
| |
Sample rows
| ID | ProductID | Description |
|---|
| 901
| 300
| <html><head><meta http-equiv=Content-Type content="text/html; charset=windows-1252"><title>Tee Shirt...
|
| 902
| 301
| <html><head><meta http-equiv=Content-Type content="text/html; charset=windows-1252"><title>Tee Shirt...
|
| 903
| 302
| <html><head><meta http-equiv=Content-Type content="text/html; charset=windows-1252"><title>Tee Shirt...
|
| 904
| 400
| <html><head><meta http-equiv=Content-Type content="text/html; charset=windows-1252"><title>Baseball ...
|
| 905
| 401
| <html><head><meta http-equiv=Content-Type content="text/html; charset=windows-1252"><title>Baseball ...
|
| 906
| 500
| <html><head><meta http-equiv=Content-Type content="text/html; charset=windows-1252"><title>Visor</ti...
|
| 907
| 501
| <html><head><meta http-equiv=Content-Type content="text/html; charset=windows-1252"><title>Visor</ti...
|
| 908
| 600
| <html><head><meta http-equiv=Content-Type content="text/html; charset=windows-1252"><title>Sweatshir...
|
| 909
| 601
| <html><head><meta http-equiv=Content-Type content="text/html; charset=windows-1252"><title>Sweatshir...
|
| 910
| 700
| <html><head><meta http-equiv=Content-Type content="text/html; charset=windows-1252"><title>Shorts</t...
|
Code
CREATE TABLE "GROUPO"."MarketingInformation" (
"ID" integer NOT NULL
,"ProductID" integer NOT NULL
,"Description" long varchar NULL
,CONSTRAINT "MarketingKey" PRIMARY KEY ("ID")
)