appointment

Tables (5)

appointment (Untitled3)

  • id (예약아이디) — INT — Primary key — NOT NULL
  • user_id (회원아이디) — INT — Foreign key → user.id — NOT NULL
  • store_id (매장아이디) — INT — Foreign key → store.id — NOT NULL
  • user_name (회원이름) — VARCHAR(50)
  • store_name (매장이름) — VARCHAR(50)
  • visited (방문여부) — TINYINT(1)
  • regi_date (예약한시간) — DATETIME(6)

review (Untitled4)

  • id (리뷰아이디) — INT — Primary key — NOT NULL
  • appointment_id (예약아이디) — INT — Foreign key → appointment.id — NOT NULL
  • review (리뷰) — TEXT

store (Untitled2)

  • id (매장아이디) — INT — Primary key — NOT NULL
  • store_name (매장이름) — VARCHAR(50)
  • store_position (매장위치) — TEXT
  • store_description (매장설명) — TEXT

user (Untitled)

  • id (회원아이디) — INT — Primary key — NOT NULL
  • user_name (회원이름) — VARCHAR(50)
  • password (비밀번호) — VARCHAR(100)

user_roles (CopyOfUntitled)

  • user_id (회원아이디) — INT — Foreign key → user.id — NOT NULL
  • roles (역활) — VARCHAR(50)