다방

테이블 (3)

가격유형 (price_type)

  • PriceType_Id (price_type_Id) — 자동증가 — 기본 키 — NOT NULL
  • Myroom_Id (my_room_Id) — 자동증가 — 외래 키 → 내방.Myroom_Id — NOT NULL
  • PriceType_name (price_type_name) — NOT NULL
  • Created_At — NOT NULL
  • Modified_At — NOT NULL

내방 (my_room)

  • Myroom_Id (my_room_Id) — primary key — 기본 키 — NOT NULL
  • Myroom_Name (my_room_Name) — NOT NULL
  • Landlord — NOT NULL
  • Region — NULL
  • Deposit — NULL
  • Rent — NULL
  • Created_At — NOT NULL
  • Modified_At — NOT NULL

방유형 (room_type)

  • RoomType_Id (room_type_Id) — 자동증가 — 기본 키 — NOT NULL
  • Myroom_Id (my_room_Id) — 자동증가 — 외래 키 → 내방.Myroom_Id — NOT NULL
  • RoomType_name (room_type_name) — NOT NULL
  • Created_At — NOT NULL
  • Modified_At — NOT NULL