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