How do I convert the following mysql tables into Django model classes? -


i new django. find hard understand how mysql table should converted django model classes , make use of django forms.

# city table   create table city (                          city_id int unique,                     city_name  varchar(15),                     primary key (city_name)               );  # station table in city may have many stations. (a, b), (a,c), (a,d) etc valid rows  create table station (                       station_id int unique,                        station_city varchar(15),                       station_name varchar(30),                       foreign key (station_city) references city(city_name),                       primary key (station_city, station_name)                                               );   # description of travelle/user books ticket  create table traveller (                    traveller_id int not null auto_increment,                    traveller_name varchar(35),                   primary key(traveller_id)                );  # ticket relation  # user choses hometown  # station belonging users hometown can selected  create table ticket (                ticket_id int not null auto_increment,                ticket_city varchar(10),                ticket_station varchar(30),                ticket_traveller int,                primary key ( ticket_id),                foreign key (ticket_city) references city(city_name),                foreign key (ticket_traveller) references traveller(traveller_id),                 foreign key (ticket_city, ticket_station) references station (station_city, station_name)                ); 

i want convert same mysql tables django classes , allow logged in user/traveller book @ ticket selecting city, followed station (from available stations in city). ticket_id , ticket_traveller should auto-fed database.


Comments

Popular posts from this blog

Command prompt result in label. Python 2.7 -

javascript - How do I use URL parameters to change link href on page? -

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -