Description
noneTable properties
| name | value |
|---|
| name | catalog |
| created | 5/3/2009 12:00:00 AM |
| row count | 74 |
| Maximum size of a single row | 16,960 bytes |
Columns
| column | datatype | length | bytes | default | nulls | PK | FK | UQ | computed | comment |
|---|
| catalog_num | serial | | 4 | | no
| yes
| |
|
| |
| stock_num | smallint | | 2 | | no
|
| composite FK to stock.stock_num
|
|
| |
| manu_code | char | | 3 | | no
|
| composite FK to stock.manu_code
|
|
| |
| cat_descr | text | (n/a) | (n/a) | | yes
|
| |
|
| |
| cat_picture | byte | | 56 | | yes
|
| |
|
| |
| cat_advert | varchar | | 16895 | | yes
|
| |
|
| |
Indexes
| name | description | column | comment |
|---|
| 108_21 | non-clustered index | catalog_num |
|
| 108_22 | non-clustered index | stock_num, manu_code |
|
References
Foreign key graph
Foreign keys
| name | column | comment |
|---|
| aa | stock_num | |
| aa | manu_code | |
Sample rows
| catalog_num | stock_num | manu_code | cat_descr | cat_picture | cat_advert |
|---|
| 10001
| 1
| HRO
| Brown leather. Specify first baseman's or infield/outfield style. Specify right- or left-handed.
|
| Your First Season's Baseball Glove
|
| 10002
| 1
| HSK
| Babe Ruth signature glove. Black leather. Infield/outfield style. Specify right- or left-handed.
|
| All Leather, Hand Stitched, Deep Pockets, Sturdy Webbing That Won't Let Go
|
| 10003
| 1
| SMT
| Catcher's mitt. Brown leather. Specify right- or left-handed.
|
| A Sturdy Catcher's Mitt With the Perfect Pocket
|
| 10004
| 2
| HRO
| Jackie Robinson signature ball. Highest professional quality, used by National League.
|
| Highest Quality Ball Available, from the Hand-Stitching to the Robinson Signature
|
| 10005
| 3
| HSK
| Pro-style wood. Available in sizes: 31, 32, 33, 34, 35.
|
| High-Technology Design Expands the Sweet Spot
|
| 10006
| 3
| SHM
| Aluminum. Blue with black tape. 31", 20 oz or 22 oz; 32", 21 oz or 23 oz; 33", 22 oz or 24 oz;
|
| Durable Aluminum for High School and Collegiate Athletes
|
| 10007
| 4
| HSK
| Norm Van Brocklin signature style.
|
| Quality Pigskin with Norm Van Brocklin Signature
|
| 10008
| 4
| HRO
| NFL Style pigskin.
|
| Highest Quality Football for High School and Collegiate Competitions
|
| 10009
| 5
| NRG
| Graphite frame. Synthetic strings.
|
| Wide Body Amplifies Your Natural Abilities by Providing More Power Through Aerodynamic Design
|
| 10010
| 5
| SMT
| Aluminum frame. Synthetic strings.
|
| Mid-Sized Racquet for the Improving Player
|
Code
create table "informix".catalog
(
catalog_num serial not null ,
stock_num smallint not null ,
manu_code char(3) not null ,
cat_descr text,
cat_picture byte,
cat_advert varchar(255,65),
primary key (catalog_num)
);
revoke all on "informix".catalog from "public" as "informix";
alter table "informix".catalog add constraint (foreign key (stock_num,
manu_code) references "informix".stock constraint "informix"
.aa);