Code snippet of database structure of Financify.

Financify.dbml

table stock{

 item_id varchar(10)

 item_name varchar(25)

 gst_slab int

 quantity mediumtexttext

 weight float(10,2)

 price float(10,2)

 username varchar(20)

}



table users{

 username varchar(15) [pk]

 password varchar(20)

 email varchar(40)

 name varchar(25)

 gender varchar(10)

}



table accounts

{

 username varchar(15)

 acc_id int [pk]

 acc_name varchar(15)

 acc_type varchar(15)

 address varchar(30)

 city varchar(30)

 state varchar(30)

 pincode int

 GST varchar(20)

 PAN varchar(20)

 email varchar(40)

 mobile mediumtext

 credit_days int

 interest int

}



table transactions

{

 bill_no varchar(10)

 date date

 debit float

 credit float

 acc_name varchar(25)

 username varchar(20)

}



table bill

{

 bill_no varchar(10)

 s_no  int

 item_id varchar(10)

 item_name varchar(25)

 pcs int

 quantity float

 net_rate float

 rate float

 amount float

 disc float

 disc_perc float

 taxable float

 gst_perc float

 gst float

 acc_name varchar(25)

 username varchar(20)

 type varchar(25)

 date date

 bill_amount float

 due_date date

 status varchar(20)

}



table voucher

{

 bill_no varchar(10)

 date date

 narration varchar(20)

 amount float

 type varchar(20)

 username varchar(20)

 cheque_number int

}


Ref: "users"."username" < "accounts"."username"


Ref: "stock"."username" < "users"."username"


Ref: "accounts"."username" < "transactions"."username"


Ref: "bill"."bill_no" < "transactions"."bill_no"


Ref: "voucher"."bill_no" < "bill"."bill_no"