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

Untitled3