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