oksae

Tables (9)

address (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • postal_code (Field) — varchar
  • road_address (Field5) — varchar
  • jibun_address (Field2) — varchar
  • location (Field3) — geometry

building (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • address_id (Key2) — bigint — Foreign key → address.id — NOT NULL
  • building_name (Field) — varchar

checklist_answer (Untitled8)

  • id (Key) — bigint — Primary key — NOT NULL
  • review_id (Key2) — bigint — Foreign key → review.id — NOT NULL
  • question_code (Field) — enum
  • answer_code (Field3) — enum

contract (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • house_id (Key3) — bigint — Foreign key → house.id — NOT NULL
  • member_id (Key2) — Foreign key → member.id — NOT NULL
  • contract_img (Field)
  • startAt (Field2) — datetime
  • endAt (Field3) — datetime
  • status (Field5) — enum
  • contract_type (Field4) — enum

house (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • building_id (Key2) — bigint — Foreign key → building.id — NOT NULL
  • dong (Field) — varchar
  • room_no (Field2) — varchar
  • floor (Field3) — varchar

member (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • email (Field3)
  • nickname (Field4)
  • onchain_address (Field5)

review (Untitled3)

  • id (Key2) — bigint — Primary key — NOT NULL
  • review_authority_id (Key) — bigint — Foreign key → review_authority.id — NOT NULL
  • visibility (Field) — enum
  • overall_score (Field2)
  • noiseproof_score (Field3)
  • water_pressure_score (Field4)
  • sunlight_score (Field5)
  • security_score (Field7)
  • cleanliness_score (Field8)

review_authority (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • contract_id (Key2) — bigint — Foreign key → contract.id — NOT NULL
  • onchain_id (Field) — varchar
  • issuedAt (Field2) — datetime
  • status (Field5) — enum
  • auth_start (Field3) — datetime
  • auth_end (Field4) — datetime
  • is_burned (Field6) — bool

risk_report (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • building_id (Key2) — bigint — Foreign key → building.id — NOT NULL
  • risk_score (Field)
  • risk_info (Field2)