About Room
Tables (7)
Book (Untitled4)
- BookId — BIGINT — Primary key — NOT NULL
- UserID — BIGINT — Foreign key → User.UserID — NOT NULL
- RoomId — BIGINT — Foreign key → Room.RoomId — NOT NULL
- People — INT — NOT NULL
- StartDate — DATETIME — NOT NULL
- EndDate — DATETIME — NOT NULL
- IsCanceled — BOOLEAN — NOT NULL
Facility (Untitled)
- FacilityId — BIGINT — Primary key
- CategoryId — VARCHAR(20)
- Name — VARCHAR(255) — NOT NULL
- Address — VARCHAR(4000) — NOT NULL
- LAT — DOUBLE — NOT NULL
- LNT — DOUBLE — NOT NULL
Image (Untitled2)
- ImageID (IamgeID) — BIGINT — Primary key — NOT NULL
- FacilityId — BIGINT — Foreign key → Facility.FacilityId
- Image1 — VARCHAR(4000) — NOT NULL
- Image2 — VARCHAR(4000) — NOT NULL
- Image3 — VARCHAR(4000)
- Image4 — VARCHAR(4000)
Likes (Untitled7)
- LikesId — BIGINT — Primary key — NOT NULL
- UserID — BIGINT — Foreign key → User.UserID — NOT NULL
- RoomId — BIGINT — Foreign key → Room.RoomId — NOT NULL
Price (Untitled5)
- PriceId — BIGINT — Primary key — NOT NULL
- RoomId — BIGINT — Foreign key → Room.RoomId — NOT NULL
- StartDate — DATETIME — NOT NULL
- EndDate — DATETIME — NOT NULL
- Price — INT — NOT NULL
- IsDiscounted — BOOLEAN — NOT NULL
- DiscountRate — INT
Room (Untitled3)
- RoomId — BIGINT — Primary key — NOT NULL
- FacilityId — BIGINT — Foreign key → Facility.FacilityId
- Content — VARCHAR(1000) — NOT NULL
- RoomCapicity — INT
- CanBeDuplicated — BOOLEAN — NOT NULL
- MaxCapicity — INT
- NowAmount — INT
User (Untitled6)
- UserID — BIGINT — Primary key — NOT NULL
- SnsYN — BOOLEAN — NOT NULL
- NonSnsUserID — VARCHAR(255)
- NonSnsPassword — VARCHAR(255)
- NickName — VARCHAR(255) — NOT NULL