search

khanshakeeb / wad18_ae_bidding_site

WAD AE/AW bidding site for leanring purpose
GNU General Public License v3.0
1 stars 0 forks source link

ERD design #2

Closed khanshakeeb closed 5 years ago

khanshakeeb commented 5 years ago

Design ERD diagram and share with everyone

danishyounus12 commented 5 years ago

erd relationship diagram erd diagram

khanshakeeb commented 5 years ago

@danishyounus12 you only need to correct columns name e.g

u_id should "uid" user_name should "username" roles_names should be "name"

in table "product_type" foreign key should be "project_id" and same for other table. Just remember the name foreign key should be table name prefix and id. e.g foreign key should =

danishyounus12 commented 5 years ago

erdplus-diagram erdplus-diagram 1 Sir @khanshakeeb, if i am doing any mistake again, kindly correct me.

Shahf172 commented 5 years ago

ERD Diagram Sir Kindly Check this And Correct if i am wrong entity_relation_diagram

khanshakeeb commented 5 years ago

@Shahf172 payment type/user payment table i dont understand over all looks good but we have to finalize one ERD version so developers will not confused. I believe you both sit together and draft a final version both are using different approach in field names.

@danishyounus12 projects_id should be project_id (should be singular field name)

Shahf172 commented 5 years ago

Payment type is for ongoing type and one time payment and user_payment is representing payment table by mistake I wrote user_payment. And I can't sit with him sir because of job late sitting issues

khanshakeeb commented 5 years ago

@Shahf172 Ok, then we have to finalize on ERD either yours or either @danishyounus12 warna it will be confusion which ERD we need to follow.

Thanks

khanshakeeb commented 5 years ago

You guys can communicate over slack infact in #general channel that is why I have created slack would be easier. Lets discuss there more quickly we will decide