ㅇㅇ

Tables (4)

camping

  • campingId — UNSIGNED — Primary key — NOT NULL
  • name — VARCHAR(255)
  • address — TEXT
  • phone — VARCHAR(20)
  • description — TEXT
  • checkIn — DATETIME
  • checkOut — DATETIME
  • site — INT — 1: 데크, 2: 파쇄석, 3: 마사토, 4: 잔디, 5:모래
  • fee — INT
  • max — INT
  • facilities — TEXT
  • img — LONGBLOB
  • category — INT — 1: 캠핑, 2: 글램핑, 3: 카라반, 4: 펜션
  • userId — UNSIGNED — NOT NULL

reservation

  • reservationId — UNSIGNED — Primary key — NOT NULL
  • total — INT — 유아, 어른 구분
  • checkIn — DATETIME
  • checkOut — DATETIME
  • state — INT — 1: 대기, 2: 확정, 3: 종료, 4: 취소
  • campingId — UNSIGNED — NOT NULL
  • userId — UNSIGNED — NOT NULL

review

  • reviewId — UNSIGNED — Primary key — NOT NULL
  • campingId — UNSIGNED — NOT NULL
  • content — TEXT
  • img — LONGBLOB

user

  • userId — UNSIGNED — Primary key — NOT NULL
  • role — INT — 1 : 고객, 2: 주인
  • id — VARCHAR(55)
  • pw — VARCHAR(55)