뽀득뽀득 ERD 초안

테이블 (11)

CarWash (세차장)

    Chat (채팅메시지)

      Chat room (채팅방)

        Lighting Match (번개 매칭)

          Manager (관리자)

            Reservation (예약)

              Review (리뷰)

                User (사용자)

                • 유저 ID (id) — 기본 키 — NOT NULL
                • 비밀번호 (pwd)
                • 차종 (VehicleInfo)
                • 세차 실력 (WashingExprience)
                • 위치 (Location)

                bay

                • id — bigint — 기본 키 — NOT NULL
                • carwash_id — bigint — NOT NULL
                • bay_num — bigint — NOT NULL
                • bay_type — varchar(50) — NOT NULL
                • price — int(11)
                • duration — int(11)

                carwash

                • id — bigint — 기본 키 — NOT NULL
                • member_id — bigint — NOT NULL
                • name — varchar(255) — NOT NULL
                • rate — int(11)
                • address — varchar(255) — NOT NULL
                • pic — varchar(255)
                • pic_type — int(11)
                • tel — varchar(255)
                • d_time — timestamp
                • w_time — timestamp
                • time_des — varchar(50)
                • des — varchar(255)
                • dzone — int(11)

                reservation

                • id — bigint — 기본 키 — NOT NULL
                • bay_id — bigint — NOT NULL
                • member_id — bigint — NOT NULL
                • start_time — timestamp
                • end_time — timestamp
                • price — int(11)