Designing & Planning Discussion

[sanket1211996]

I have created this first draft of napkin diagram. Let me know what can we improve or add in this.

Napkin Diagram

[richajha012]

we can add like "if yes then this is the right platform for you" because ultimately we are giving that functionality so we can show that right ?? Let me know If I'm right

[sanket1211996]

Yes, thats a good point. But I actually had added similar line on the central part.

[richajha012]

yes right, Its looks perfect

[sumedhsalvi]

The napkin diagram looks perfect. Also, we need to draw a sequence diagram of architecture in the Napkin style.

[sanket1211996]

Sure

[sumedhsalvi]

Minor typo correction - missing apostrophe for word "earths" in the statement 'Get Eagle of earth weather, with weather data'

[sanket1211996]

Sure, I will update this.

[sanket1211996]

I have updated the PR. Verify and merge.

[sumedhsalvi]

I have verified and merged the changes. You can close the issue

[sanket1211996]

I have added the user dashboard wireframe diagram. #27 . Take a look and let me know if any changes needed.

[sanket1211996]

https://github.com/airavata-courses/SuperNova/wiki/User-Dashboard-Wireframe

[sumedhsalvi]

I have created a Project Planning diagram. #29 Please take a look and let me know if any changes are required.

[sanket1211996]

I have reviewed the PR. Good Job. Merged the PR. Do add it to wiki pages. @sumedhsalvi

[sumedhsalvi]

Added to Wiki Page.
https://github.com/airavata-courses/SuperNova/wiki/Project-Planning-Diagram

[sanket1211996]

USER API DATABASE DESIGN CHANGES
session-info
PK(id) AUTO_INC , FK(userID) NOT NULL, radStation dataTime sessionTime
1 ABC T T
1 ABC T T
2. BCD T T

user-info
PK(id) AUTO_INC, email NOT_NULL

1. sanket
2. ricjha

[richajha012]

yea missed it . Thanks

[richajha012]

create table SessionInfo(
id INT AUTO_INCREMENT,
user_id INT NOT NULL,
radStation VARCHAR(250),
dataTime Date,
SessionTime TIMESTAMP,
PRIMARY KEY ( id ),
FOREIGN KEY (user_id) REFERENCES UserInfo(user_id)
);

create table UserInfo(
user_id INT AUTO_INCREMENT,
user_email VARCHAR(250) NOT NULL,
PRIMARY KEY ( user_id )
);

[sanket1211996]

UserInfo table should have id field not user_id. Reference table should have named the Foreign key as user_id.

[sanket1211996]

userID

[richajha012]

I have Created Pull requests for user DB scripts and user DB diagrams for issues #1, #34, Please review and merge.

[sanket1211996]

I am tagging all the issue with project 1 label. Hence forth all the new issues will be tagged with project label. @richajha012 @sumedhsalvi

[sumedhsalvi]

Okay. Noted!

[sanket1211996]

I have design a high level architecture, as discuss and proposed design. Do review and merge. @sumedhsalvi @richajha012

[sumedhsalvi]

I have reviewed and requested small corrections.
Please check.

[sanket1211996]

Good catch, modified the needful. Please do review and merge.

[sumedhsalvi]

I have reviewed and merged the changes.