FINAL DATABASE TERM PROJECT
Tables (33)
ADMINISTRATIVE ASSISTANT (Untitled11)
- Assistant_ID (Key) — Primary key — NOT NULL
- Assistant_Name (Field)
ARTICLE (Untitled20)
- Article_ID (Key) — Primary key — NOT NULL
- Article_Date (Field2)
- Article_Url (Field)
ARTICLE_ARTIST (Untitled21)
- Article_ID (Key) — Foreign key → ARTICLE.Article_ID — NOT NULL
- SArtist_ID (Key2) — Foreign key → SIGNED ARTIST.SArtist_ID — NOT NULL
- Article_Summary (Field)
ARTIST (Untitled)
- Artist_ID (Key) — Primary key — NOT NULL
- Artist_Name (Field)
- Artist_Gender (Field3)
- Artist_Adress(street,city, state,country) (Field2)
- Artist_PhoneNumber (Field4)
- Artist_Instrument (Field5)
- Artist_Email (Field6)
- Artist_University Dergree (Field7)
- Artist_Honors (Field8)
- Manager_ID (Key2) — Foreign key → ARTIST_MANAGER.Manager_ID — NOT NULL
ARTIST_CALENDAR (Untitled22)
- SArtist_ID (Key) — Foreign key → SIGNED ARTIST.SArtist_ID — NOT NULL
- Calendar_ID (Key2) — Foreign key → CALENDAR.Calendar_ID — NOT NULL
- Priority Number (Field)
ARTIST_MANAGER (Untitled10)
- Manager_ID (Key) — Primary key — NOT NULL
- Manager_Name (Field)
- Assistant_ID (Key2) — Foreign key → ADMINISTRATIVE ASSISTANT.Assistant_ID — NOT NULL
ARTIST_PAYMENT (Untitled33)
- APayment_ID (Key) — Primary key — NOT NULL
- APayment_Date (Field)
- Apayment_Amount (Field2)
- SArtist_ID (Key2) — Foreign key → SIGNED ARTIST.SArtist_ID — NOT NULL
- Invoice_ID (Key3) — Foreign key → PAYMENT.Invoice_ID — NOT NULL
- Event_ID (Key222) — Foreign key → PAYMENT.Event_ID — NOT NULL
AUTHORITY GROUP (Untitled24)
- AGP_ID (Key) — Primary key — NOT NULL
- AGP_Name (Field)
AUTHORITYGP_ASSISTANT (Untitled26)
- AGP_ID (Key) — Foreign key → AUTHORITY GROUP.AGP_ID — NOT NULL
- Assistant_ID (Key2) — Foreign key → ADMINISTRATIVE ASSISTANT.Assistant_ID — NOT NULL
AUTHORITYGP_MANAGER (Untitled25)
- AGP_ID (Key) — Foreign key → AUTHORITY GROUP.AGP_ID — NOT NULL
- Manager_ID (Key2) — Foreign key → ARTIST_MANAGER.Manager_ID — NOT NULL
AUTHORITY_ARTIST (Untitled27)
- SArtist_ID (Key) — Foreign key → SIGNED ARTIST.SArtist_ID — NOT NULL
- AGP_ID (Key2) — Foreign key → AUTHORITY GROUP.AGP_ID — NOT NULL
AUTHORITY_CUSTOMER (Untitled29)
- AGP_ID (Key) — Foreign key → AUTHORITY GROUP.AGP_ID — NOT NULL
- Customer_ID (Key2) — Foreign key → CUSTOMER.Customer_ID — NOT NULL
CALENDAR (Untitled6)
- Calendar_ID (Key2) — Primary key — NOT NULL
- Calendar_Name (Field5)
- Calendar_StartTime (Field)
- Calendar_EndTime (Field2)
- Calender_color (Field3)
- TimeStamp (Field4)
CALENDAR_AUTHORITY (Untitled23)
- Calendar_ID (Key2) — Foreign key → CALENDAR.Calendar_ID — NOT NULL
- AGP_ID (Key) — Foreign key → AUTHORITY GROUP.AGP_ID — NOT NULL
- Access_Available (Field)
- Change_Available (Field2)
- Timeblock_Available (Field3)
- TentativeChange_Available (Field4)
- Lookup_Available (Field5)
- Priority_FillIn (Field6)
- Priority_Change (Field7)
CONTRACT (Untitled16)
- Contract_ID (Key) — Primary key — NOT NULL
- Artist_ID (Key2) — Foreign key → ARTIST.Artist_ID — NOT NULL
- RoyaltyRate (Field3)
- Contract_StartDate (Field)
- Contract_EndDate (Field2)
- Contract_Memo (Field4)
- TERM (Field5)
- Expected_RoyaltyRate (Field6)
CONTRACT_ALARM (Untitled28)
- Alarm_ID (Key3) — Primary key — NOT NULL
- Contract_ID (Key) — Foreign key → CONTRACT.Contract_ID — NOT NULL
- Artist_ID (Key2) — Foreign key → CONTRACT.Artist_ID — NOT NULL
- AlarmTime (Field)
- AlarmType (Field2)
- AlarmTargetID (Field3)
- ReadAt (Field4)
COST (Untitled13)
- Cost_ID (Key) — Primary key — NOT NULL
- Cost_AccountName (Field)
- Cost_Amount (Field2)
- Cost_Date (Field3)
- Purchaser_ID (Field5)
- Purchaser_typeCode (Field4)
COST_ARTIST (Untitled15)
- Cost_ID (Key) — Foreign key → COST.Cost_ID — NOT NULL
- Artist_ID (Key2) — Foreign key → ARTIST.Artist_ID — NOT NULL
COST_MANAGER (Untitled14)
- Cost_ID (Key) — Foreign key → COST.Cost_ID — NOT NULL
- Manager_ID (Key2) — Foreign key → ARTIST_MANAGER.Manager_ID — NOT NULL
- Cost_typeCode (Field)
CUSTOMER (Untitled5)
- Customer_ID (Key) — Primary key — NOT NULL
- Customer_Name (Field)
- Customer_Number (Field3)
- Customer_Adress (Field2)
ECT_MGR_COST (Untitled19)
- ECost_ID (Key) — Foreign key → COST_MANAGER.Cost_ID — NOT NULL
EVENT (Untitled7)
- Event_ID (Key2) — Primary key — NOT NULL
- Customer_ID (Key) — Foreign key → CUSTOMER.Customer_ID — NOT NULL
- Event_Name (Field)
- Event_Status (Field2)
- Event_StartTime (Field3)
- Event_EndTime (Field4)
- Event_Location (Field5)
- Event_Type (Field6)
- Event_Memo (Field7)
EVENT-ART_AUTHORITY (Untitled30)
- Event_ID (Key2) — Foreign key → EVENT_ARTIST.Event_ID — NOT NULL
- Customer_ID (Key3) — Foreign key → EVENT_ARTIST.Customer_ID — NOT NULL
- AGP_ID (Key4) — Foreign key → AUTHORITY GROUP.AGP_ID — NOT NULL
- Lookup_Available (Field)
EVENT_ARTIST (Untitled12)
- SArtist_ID (Key) — Foreign key → SIGNED ARTIST.SArtist_ID — NOT NULL
- Event_ID (Key2) — Foreign key → EVENT.Event_ID — NOT NULL
- Customer_ID (Key3) — Foreign key → EVENT.Customer_ID — NOT NULL
- Payment (Field)
- Attendance (Field2)
INVOICE (Untitled8)
- Invoice_ID (Key) — Primary key — NOT NULL
- Event_ID (Key2) — Foreign key → EVENT.Event_ID — NOT NULL
- Customer_ID (Key3) — Foreign key → EVENT.Customer_ID — NOT NULL
- Invoice_Amount (Field)
- Invoice_Date (Field2)
- Invoice_Tax (Field3)
- Assistant_ID (Key4) — Foreign key → ADMINISTRATIVE ASSISTANT.Assistant_ID — NOT NULL
MANAGER_INQUIRY (Untitled17)
- Inquiry_ID (Key) — Primary key — NOT NULL
- Inqury_Summary (Field)
- Incoming_PhoneNumber (Field2)
- IncomingDate (Field3)
- RespondStatus (Field4)
- Assistant_ID (Key2) — Foreign key → ADMINISTRATIVE ASSISTANT.Assistant_ID — NOT NULL
PAYMENT (Untitled9)
- Payment_ID (Key2) — Primary key — NOT NULL
- Invoice_ID (Key) — Foreign key → INVOICE.Invoice_ID — NOT NULL
- Event_ID (Key22) — Foreign key → INVOICE.Event_ID — NOT NULL
- Payment_State (Field)
- Payment_Date (Field3)
- Due_Date (Field2)
PROSPECTIVE ARTIST (Untitled3)
- PArtist_ID (Key) — Foreign key → ARTIST.Artist_ID — NOT NULL
RECOMMENDATION (Untitled32)
- Artist_ID (Key) — Foreign key → ARTIST.Artist_ID — NOT NULL
- Story_ID (Key2) — Foreign key → STORY.Story_ID — NOT NULL
- Story_Summary (Field)
SAMPLE MUSIC (Untitled34)
- Music_ID (Key) — Primary key — NOT NULL
- SArtist_ID (Key2) — Foreign key → SIGNED ARTIST.SArtist_ID — NOT NULL
- MusicFile (Field)
- MusicDate (Field2)
SIGNED ARTIST (Untitled2)
- SArtist_ID (Key) — Foreign key → ARTIST.Artist_ID — NOT NULL
STORY (Untitled31)
- Story_ID (Key) — Primary key — NOT NULL
- Story_Title (Field)
- Story_url (Field2)
- Story_Date (Field3)
- Story_Name (Field4)
TRAVEL_MGR_COST (Untitled18)
- TCost_ID (Key) — Foreign key → COST_MANAGER.Cost_ID — NOT NULL