WEB3_4_Poten_BE
테이블 (7)
Cafe(카페) (Untitled2)
- cafe_id (Key) — Long — 기본 키 — NOT NULL
- owner_id (Field7) — Long
- name (Field) — String
- address (Field2) — String
- latitude (Field3) — Double
- longitude (Field4) — Double
- phone (Field5) — String
- description (Field6) — String
- created_at (Field8) — DATETIME
- updated_at (Field9) — DATETIME
- image (Field10) — String
- disabled (Field11) — Boolean
Cafe_Application(카페 신청) (Untitled7)
- id (Key) — Long — 기본 키 — NOT NULL
- id (Key2) — member_id — 외래 키 → Member(회원).id — NOT NULL
- name (Field2) — String
- address (Field3) — String
- phone (Field4) — String
- status (Field6) — ENUM(PENDING, APPROVED,REJECTED)
- created_at (Field7) — DATETIME
Member(회원) (Untitled)
- id (Key) — Long — 기본 키 — NOT NULL
- name (Field) — String
- email (Field2) — String
- password (Field3) — String
- role (Field4) — String
- created_at (Field5) — DATETIME
- updated_at (Field6) — DATETIME
- oAuth_id (Field7) — String
- sns (Field8) — Enum
- profileimage (Field9) — String
Payment(결제) (Untitled6)
- id (Key) — Long — 기본 키 — NOT NULL
- user_id (Field) — Long
- reservation_id (Field2) — Long
- amount (Field3) — DECIMAL(10,2)
- status (Field4) — Enum
- created_at (Field5) — DATETIME
- updated_at (Field6) — DATETIME
Reservation(예약) (Untitled5)
- id (Key) — Long — 기본 키 — NOT NULL
- payment_id (Key2) — Long — 외래 키 → Payment(결제).id — NOT NULL
- user_id (Key3) — Long — 외래 키 → Member(회원).id — NOT NULL
- cafe_id (Key4) — Long — 외래 키 → Cafe(카페).cafe_id — NOT NULL
- seat_id (Field2) — Long
- reservation_date (Field3) — DATE
- start_time (Field4) — TIME
- end_time (Field5) — TIME
- status (Field6) — Enum
- created_at (Field7) — DATETIME
- updated_at (Field8) — DATETIME
Review(리뷰) (Untitled4)
- id (Field6) — Long — 기본 키
- user_id (Key) — Long — 외래 키 → Member(회원).id — NOT NULL
- cafe_id (Key2) — Long — 외래 키 → Cafe(카페).cafe_id — NOT NULL
- rating (Field3) — int
- comment (Field2) — String
- created_at (Field4) — DATETIME
- updated_at (Field5) — DATETIME