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