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
Post a Comment