MovieProject
Tables (5)
cities
- cityId — int(11) — Primary key — NOT NULL
- siName — varchar(100) — NOT NULL
- guName — varchar(100) — NOT NULL
favoriteTheaters
- favoriteTheatersId — int(11) — NOT NULL
- userCode — int(11) — Foreign key → users.userCode — NOT NULL
- theaterId — int(11) — Foreign key → theaters.theaterId — NOT NULL
- theaterName — varchar(45) — NOT NULL
- theaterBrand — varchar(45) — NOT NULL
theaters
- theaterId — int(11) — Primary key — NOT NULL
- cityId — int(11) — Foreign key → cities.cityId — NOT NULL
- theaterName — varchar(50) — NOT NULL
- theaterAddress — varchar(255) — NOT NULL
- theaterBrand — varchar(50) — NOT NULL
- theaterLat — double
- theaterLon — double
theaters_urls
- id — int(11) — Primary key — NOT NULL
- brand — varchar(50)
- name — varchar(100)
- url — varchar(255)
users
- userCode — int(11) — Primary key — NOT NULL
- userEmail — varchar(45) — NOT NULL
- userName — varchar(45) — NOT NULL
- userNick — varchar(45) — NOT NULL
- userPw — varchar(300) — NOT NULL
- userGender — int(11) — NOT NULL
- userBirth — date — NOT NULL
- userLoginkind — int(11) — NOT NULL