ERD 프로그램 실습

테이블 (5)

Booking (Untitled2)

  • booking (ID) — INT — 기본 키 — NOT NULL
  • property (ID1) — INT
  • user (ID2) — INT
  • checkinDate (/) — DATE
  • checkoutDate (//) — DATE
  • totalprice (///) — DECIMAL(10.2)
  • Field (////) — TIMESTAMP

Messages (Untitled)

  • message (ID) — INT — 기본 키 — NOT NULL
  • sender (ID1) — INT
  • receiver (ID2) — INT
  • message (TEXT) — TEXT
  • sendDate (date) — TIMESTAMP

Properties (Untitled3)

  • property (ID) — INT — 기본 키 — NOT NULL
  • booking (ID2) — INT — 외래 키 → Booking.booking — NOT NULL
  • user (ID4) — INT — 외래 키 → Untitled.user — NOT NULL
  • message (ID22) — INT — 외래 키 → Untitled.message — NOT NULL
  • user (ID1) — INT
  • title (/) — VARCHAR(255)
  • description (//) — TEXT
  • address (///) — VARCHAR(255)
  • pricePerNight (////) — DECIMAL(10,2)
  • createDate (/////) — TIMESTAMP
  • booking (ID3) — INT — 외래 키 → Booking.booking — NOT NULL

Reviews (Untitled4)

  • review (ID) — INT — 기본 키 — NOT NULL
  • property (ID1) — INT
  • user (ID2) — INT
  • rrating (ID3) — INT
  • comment (Field) — TEXT
  • review (Date) — TIMESTAMP
  • user (ID4) — INT — 외래 키 → Untitled.user — NOT NULL
  • message (ID22) — INT — 외래 키 → Untitled.message — NOT NULL
  • property (ID5) — INT — 외래 키 → Properties.property — NOT NULL
  • booking (ID23) — INT — 외래 키 → Properties.booking — NOT NULL
  • user (ID42) — INT — 외래 키 → Properties.user — NOT NULL
  • message (ID222) — INT — 외래 키 → Properties.message — NOT NULL

Untitled (Users)

  • user (ID) — INT — 기본 키 — NOT NULL
  • message (ID2) — INT — 외래 키 → Messages.message — NOT NULL
  • Name (255) — VARCHAR
  • emill (Field) — VARCHAR
  • password (1234) — VARCHAR
  • createDate (date) — TIMESTAMP
  • message (ID3) — INT — 외래 키 → Messages.message — NOT NULL
  • property (ID4) — INT — 외래 키 → Properties.property — NOT NULL
  • booking (ID22) — INT — 외래 키 → Properties.booking — NOT NULL
  • user (ID42) — INT — 외래 키 → Properties.user — NOT NULL
  • message (ID222) — INT — 외래 키 → Properties.message — NOT NULL