all oracle tables(revised).xls - d_cds CD_NUMBER TITLE The...

This preview shows page 1 - 2 out of 5 pages.

d_cds d_job_assignments CD_NUMBER TITLE PRODUCER YEAR PARTNER_ID EVENT_ID JOB_DATE STATUS 90 The Celebrants Live in Old Town Records 1997 11 105 2-Feb-04 Visited 91 Party Music for All Occa The Music Man 2000 92 Back to the Shire Middle Earth Records 2002 d_packages 93 Songs from My Childho Old Town Records 1999 CODE LOW_RANGE HIGH_RANGE 94 Carpe Diem R&B Inc. 2000 79 500 2500 95 Here Comes the Bride The Music Man 2001 87 2501 5000 96 Graduation Songbook Tunes Are Us 1998 112 5001 10000 98 Whirled Peas Old Town Records 2004 200 10001 15000 d_clients CLIENT_NUMBER FIRST_NAME LAST_NAME PHONE EMAIL 5922 Hiram Peters 3715832249 [email protected] 5857 Serena Jones 7035335900 [email protected] 6133 Lauren Vigil 4072220090 [email protected] d_events ID NAME EVENT_DATE DESCRIPTION COST VENUE_ID PACKAGE_CODE THEME_CODE CLIENT_NUMBER 100 Peters Graduation 14-May-04 Party for 200, red, white 8000 100 112 200 5922 105 Vigil wedding 28-Apr-04 Black tie at Four Season 10000 220 200 200 6133 d_partners ID FIRST_NAME LAST_NAME EXPERTISE SPECIALTY AUTH_EXPENSE_AMT MANAGER_ID PARTNER_TYPE 11 Jennifer cho Weddings All Types 33 Wedding Coordinator 22 Jason Tsang Hip Hop 33 Disk Jockey 33 Allison Plumb Event Planning 300000 33 Manager d_play_list_items d_songs EVENT_ID SONG_ID COMMENTS ID TITLE DURATION ARTIST TYPE_CODE 100 45 Play late 45 Its Finally Over 5 min The Hobbits 12 100 46 46 Im Going to Miss My Teacher 2 min Jane Pop 12 100 47 Play early 47 Hurrah for Today 3 min The Jubilant Trio 77 105 48 Play after cake cutting 48 Meet Me At the Altar 6 min Bobby West 1 105 49 Play first 49 Lets Celebrate 8 min The Celebrants 77 105 47 Play for the father 50 All These Years 10 min Diana Crooner 88 d_venues ID LOC_TYPE ADDRESS RENTAL_FEE COMMENTS 100 Private Home 52 West End Drive, Los Angeles, 0 Large kitchen, spacious lawn 105 Private Home 123 Magnolia Road, Hudson, N.Y 0 3 level townhouse, speakers on all floors 101 Private Home

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture