ㅇㅇ
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)