table_fotoData

USE A19095_A1DBS_Projekt;
CREATE TABLE fotoData
(
photoID INT NOT NULL IDENTITY(1, 1),
pName VARCHAR(30) NOT NULL,
pAuthor VARCHAR(50),
pSize INT,
pWidth INT,
pHeight INT,
pShotTime TIMESTAMP,
pUploadTime datetime NOT NULL DEFAULT (GETDATE()),
pShotLocation VARCHAR(100),
pCamera VARCHAR(50),
pTag VARCHAR(100),
pCategory VARCHAR(50) NOT NULL,
PRIMARY KEY (photoID)
);