Scribd Logo
Upload

Welcome to Scribd!

  • 44 views

    ERD Prediction PDF

    Uploaded by

    Josland Ongi
    This document contains an entity relationship diagram showing the relationships between various tables related to soccer matches, predictions, users, teams and more. The diagram shows primary and foreign keys connecting tables like tbl_user, tbl_prediction, tbl_team, tbl_match and others.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    ERD Prediction PDF

    Uploaded by

    Josland Ongi
    44 views1 page
    This document contains an entity relationship diagram showing the relationships between various tables related to soccer matches, predictions, users, teams and more. The diagram shows primary and foreign keys connecting tables like tbl_user, tbl_prediction, tbl_team, tbl_match and others.

    Original Title

    ERD_prediction.pdf

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains an entity relationship diagram showing the relationships between various tables related to soccer matches, predictions, users, teams and more. The diagram shows primary and foreign keys connecting tables like tbl_user, tbl_prediction, tbl_team, tbl_match and others.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    44 views1 page

    ERD Prediction PDF

    Uploaded by

    Josland Ongi
    This document contains an entity relationship diagram showing the relationships between various tables related to soccer matches, predictions, users, teams and more. The diagram shows primary and foreign keys connecting tables like tbl_user, tbl_prediction, tbl_team, tbl_match and others.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 1

    tbl_role tbl_team

    PK role_id tbl_user tbl_match PK team_id


    tbl_pediction
    PK user_id PK match_id
    role_desc PK prediction_id team_name
    username match_date team_short_name
    FK1 match_id team_stadium
    password match_time
    FK2 user_id
    firstname venue
    pred_home_score
    lastname team_id_home
    pred_away_score
    email team_id_away
    point_correct_score
    no_ic home_ft_score
    point_bonus_score
    card_no_mcfc away_ft_socre
    tbl_mcm card_no_mcm win_draw_lose
    card_no_mcm_neg city_point
    PK mcm_id
    mcm_neg FK1 team_id
    adress
    mcm_neg_nama1
    user_role
    mcm_neg_nama2 tbl_marking
    no_phone
    mcm_logo
    FK1 role_id PK marking_id
    mcm_pengerusi
    FK2 mcm_id
    mcm_tim_pengerusi
    mcm_setiausaha FK1 match_id
    mcm_bendaharai correct_score_point
    bonus_score_point1
    bonus_score_point2

    You might also like