테이블링

테이블 (6)

Copy Of Copy Of STORE (managers)

  • ID (id) — bigint — 기본 키 — NOT NULL
  • 상점명 (email) — varchar — NOT NULL
  • Field (password) — varchar — NOT NULL
  • 설명 (nickname) — varchar
  • 전화번호 (phone) — varchar — NOT NULL
  • 오픈시간 (login_type) — varchar — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (modified_at) — datetime

Copy Of RESERVATION (reviews)

  • ID (id) — bigint — 기본 키 — NOT NULL
  • Field (rating) — double — NOT NULL
  • Field (comment) — varchar
  • Field (created_at) — datetime — NOT NULL

Copy Of STORE (members)

  • ID (id) — bigint — 기본 키 — NOT NULL
  • 상점명 (email) — varchar — NOT NULL
  • Field (password) — varchar — NOT NULL
  • 설명 (nickname) — varchar
  • 전화번호 (phone) — varchar — NOT NULL
  • 오픈시간 (login_type) — varchar — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (modified_at) — datetime

RESERVATION (tabling)

  • ID (id) — bigint — 기본 키 — NOT NULL
  • Field (time) — time — NOT NULL
  • Field2 (created_at) — datetime — NOT NULL

STORE (restaurants)

  • ID (id) — bigint — 기본 키 — NOT NULL
  • Field (manager_id) — bigint — NOT NULL
  • 상점명 (store_name) — varchar — NOT NULL
  • Field (status) — varchar — NOT NULL
  • 전화번호 (phone) — varchar — NOT NULL
  • 주소 (address) — json
  • 설명 (description) — varchar
  • Field (rating) — double — NOT NULL
  • 오픈시간 (open_at) — time
  • 마감시간 (close_at) — time
  • Field (created_at) — datetime — NOT NULL
  • Field (modified_at) — datetime

Untitled (alarm)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (alarm_type) — varchar — NOT NULL
  • Field (message) — varchar — NOT NULL
  • Field (read_at) — datetime
  • Field (created_at) — datetime — NOT NULL