Text file and table properties below:
Text File
1
Untitled
Mark Rothko
Oil
1961
5'9"x4'2"2
The Letter
Jan Vermeer
Oil
1666
1'5.25"x1'3.75"3
Four Apostles
Albrecht Durer
Oil
1526
7'1"x2'6"4
Big Self-Portrait
Chuck Close
Acrylic
1968
8'11"x6'11"x25
Three Angels
Andrei Rublyev
Tempura on wood
1410
4'8"x3'9"6
Voltaire
Jean-Antoine Houdon
Marble
17817
Jaguar Devouring a Hare
Antoine-Louis Barye
Bronze
1851
1'4"x3'1"8
The Peacock Skirt
Aubrey Beardsley
Pen and Ink
18949
Untitled Film Still #35
Cindy Sherman
Black-and-white photograph
1979
10"x8"10
Reclining Figure
Henry Moore
Elm wood
1939
3'1"x2'6"
Table Properties
Can you use DTS? If so, that would be a lot easier. It will create all the code for you.
tbl_Items
ID(int) - Primary Key
Title (varchar - 50)
Owner (varchar - 50)
Canvas (varchar - 20)
Copyright (char - 4)
Sized (varchar - 20)
没有评论:
发表评论