MyDB_04
Tables (11)
Album
- AlbumID — INTEGER — Primary key — NOT NULL
- RegisteredDate — Date
- ISBN — VARCHAR(20)
- Title — VARCHAR(20)
Collaborate making
- CollaborationID — INTEGER — Primary key — NOT NULL
- MusicID — INTEGER — Foreign key → Music.MusicID — NOT NULL
- MusicianID — INTEGER — Foreign key → Music.MusicianID — NOT NULL
Instrument
- InstrumentID — INTEGER — Primary key — NOT NULL
- Type — VARCHAR(20)
Instrument_Pitch
- InstrumentID — INTEGER — Foreign key → Instrument.InstrumentID — NOT NULL
- Pitch — VARCHAR(20) — Foreign key → Pitch.Pitch — NOT NULL
Make Music
- MusicianID — INTEGER — Foreign key → Musician.MusicianID — NOT NULL
- MusicID — INTEGER — Foreign key → Music.MusicID — NOT NULL
Music
- MusicID — INTEGER — Primary key — NOT NULL
- AlbumID — INTEGER — Foreign key → Album.AlbumID — NOT NULL
- MusicianID — INTEGER — Foreign key → Producer.MusicianID — NOT NULL
- Name — VARCHAR(20)
- Author — VARCHAR(20)
Musician
- MusicianID — INTEGER — Primary key — NOT NULL
- CollaborationID — INTEGER — Foreign key → Collaborate making.CollaborationID
- Name — VARCHAR(20)
Musician_Address
- Address — VARCHAR(20) — Primary key — NOT NULL
- MusicianID — INTEGER — Foreign key → Musician.MusicianID — NOT NULL
- TelephoneNo — VARCHAR(20)
Pitch (Untitled12)
- Pitch — VARCHAR(20) — Primary key — NOT NULL
Play
- MusicianID — INTEGER — Foreign key → Musician.MusicianID — NOT NULL
- InstrumentID — INTEGER — Foreign key → Instrument.InstrumentID — NOT NULL
Producer
- ProducerID — INTEGER — Primary key — NOT NULL
- AlbumID — INTEGER — Foreign key → Album.AlbumID — NOT NULL
- MusicianID — INTEGER — Foreign key → Musician.MusicianID — NOT NULL