fineman_record
Tables (6)
Album
- ISBN (Key) — int — Primary key — NOT NULL
- Title (Key2) — varcjar(20) — Foreign key → Song.Title — NOT NULL
- RegisteredDate (Field2) — Date
Instrument (Untitled)
- InstrumentID (Key) — int — Primary key — NOT NULL
- Type (Field) — varchar(10)
- pitch (Field2) — varchar(10)
Musician
- MusiciainID (Key) — int — Primary key — NOT NULL
- Name (Field) — nvarchar(10)
- Address (Field2) — varchar(20)
- TelephoneNo (Field3) — varchar(15)
MusicianInstrument (Untitled4)
- MusiciainID (Key3) — int — Foreign key → Musician.MusiciainID — NOT NULL
- InstrumentID (Key) — int — Foreign key → Instrument.InstrumentID — NOT NULL
Producer (Untitled3)
- ProducerID (Key) — int — Primary key — NOT NULL
- ISBN (Key2) — int — Foreign key → Album.ISBN — NOT NULL
- Title (Key22) — varcjar(20) — Foreign key → Album.Title — NOT NULL
- MusiciainID (Key3) — int — Foreign key → Musician.MusiciainID — NOT NULL
Song (Untitled2)
- Title (Key) — varcjar(20) — Primary key — NOT NULL
- Author (Field) — varchar(20)