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)