Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

editors Table

This table contains information about editors. Four columns (ed_id, phone, state, zip) are fixed-length character datatype. The other columns are all variable-length character datatype. There is a unique index on ed_id and another index (nonunique) on the combination of editor last and first name. The ID and name columns do not allow NULL—the others do.

						ed_id       ed_lname         ed_pos      phone        address           city state zip ed_boss
						            ed_fname
not null    not null         null        null         null                             null
edidind
						ednmind
=========== ================ =========== ============ ================= ==============
 =========== 321-55-8906 DeLongue project 415 843-2222 3000 6th St. Berkeley ...