project_beta
Tables (11)
Untitled (유저)
- Key (id) — varchar — Primary key — NOT NULL
- Field (password) — varchar
- Field (role) — char
- Field (name) — varchar
- Field (phone) — varcahr
- Field (nickname) — varchar
- Field (older) — int
- Field (gender) — char
- Field (nation) — char
- Field (date) — datetime
- Field (state) — boolean
- Field (picture) — varchar
Untitled (리뷰_히스토리)
- Key (r_num) — auto_increase — Foreign key → Untitled2.Key — NOT NULL
- Field (title) — varchar
- Field (writer) — varchar
- Field (c_time) — datetime
- Field (state) — boolean
- Field (m_time) — datetime
- Field (file_path) — varchar
- Field (file_name) — varchar
- Field (content) — varchar
Untitled (유저_히스토리)
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (log) — varchar
- Field (date) — datetime
Untitled (별점)
- Key (seq) — auto_increase — Primary key — NOT NULL
- Key (num) — auto_increase — Foreign key → Untitled.Key — NOT NULL
- Field (taste) — double
- Field (cleanliness) — double
- Field (diversity) — double
- Field (service) — double
- Field (interior) — double
- Field (date) — datetime
- Field (writer) — varchar
- Field (average) — double
Untitled (장소)
- Key (num) — auto_increase — Primary key — NOT NULL
- Field (name) — varchar
- Field (date) — datetime
- Field (cleanliness) — double
- Field (taste) — double
- Field (service) — double
- Field (diversity) — double
- Field (interior) — double
- Field (average) — double
- Field (address) — varchar
- Field (phone) — varchar
- Field (location_x) — double
- Field (location_y) — double
Untitled (알레르기)
- Key (num) — auto_increase — Foreign key → Untitled.Key — NOT NULL
- Field (allergy) — varchar
- Field (state) — boolean
Untitled (파일_히스토리)
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (file_name) — varchar
- Field (file_path) — varchar
- Field (file_size) — varchar
- Field (date) — datetime
Untitled (이미지)
- Key (seq) — auto_increase — Primary key — NOT NULL
- Key (num) — auto_increase — Foreign key → Untitled.Key — NOT NULL
- Field (file_name) — varchar
- Field (file_path) — varchar
Untitled (메뉴)
- Key (num) — auto_increase — Foreign key → Untitled.Key — NOT NULL
- Field (menu) — varchar
Untitled (유저_알레르기)
- Key (id) — varchar — Foreign key → Untitled.Key — NOT NULL
- Field (allergy) — varchar
Untitled2 (리뷰)
- Key (r_num) — auto_increase — Primary key — NOT NULL
- Key (num) — auto_increase — Foreign key → Untitled.Key — NOT NULL
- Key (seq) — auto_increase — Foreign key → Untitled.Key — NOT NULL
- Field (title) — varchar
- Field (c_time) — datetime
- Field (state) — boolean
- Field (file_path) — varchar
- Field (file_name) — varchar
- Field (content) — varchar
- Field (writer) — varchar