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