FINAL-1TEAM
Tables (9)
chat_log (대화기록)
- chat_id (PK) — int — Primary key — NOT NULL
- user_id (PK2) — int — Foreign key → user.user_id — NOT NULL
- role (Field) — varchar(10) — NOT NULL
- message (Field2) — text — NOT NULL
- create_at (Field3) — timestamp — NOT NULL
favorite (찜목록)
- id (PK) — int — Primary key — NOT NULL
- item_id (FK) — int — Foreign key → item.item_id — NOT NULL
- id (FK2) — int — Foreign key → item.id — NOT NULL
- id (FK3) — int — Foreign key → item.id — NOT NULL
- user_id (PK2) — int — Foreign key → user.user_id — NOT NULL
- created_at (Field) — timestamp
item (매물기본)
- item_id (PK) — int — Primary key — NOT NULL
- id (FK) — int — Foreign key → item_features.item_id — NOT NULL
- id (FK2) — int — Foreign key → user.user_id — NOT NULL
- url (Field) — text — NOT NULL
- deposit (Field2) — int — NOT NULL
- rent (Field3) — int — NOT NULL
- manage_cost (Field4) — int — NOT NULL
- click (Field6) — int — NOT NULL
- status (Field7) — varchar(20) — NOT NULL
- title (Field8) — varchar(255)
- address (Field9) — varchar(255) — NOT NULL
- service_type (Field10) — varchar(50)
- room_type (Field11) — varchar(50)
- floor (Field12) — varchar(20)
- all_floor (Field13) — varchar(20)
- area_m2 (Field14) — numeric(10, 2)
- lat (Field15) — numeric(10, 8) — NOT NULL
- lng (Field16) — numeric(11, 8) — NOT NULL
- image_thumbnail (Field17) — text
- first_crawled_at (Field18) — timestamp
- updated_at (Field5) — timestamp — NOT NULL
item_features (매물상세)
- item_id (PK) — int — Primary key — NOT NULL
- has_parking (Field) — bool
- parking_count (Field2) — numeric(10, 2)
- has_elevator (Field3) — bool
- bathroom_count (Field4) — int
- residence_type (Field5) — varchar(50)
- room_direction (Field6) — varchar(20)
- item_features (Field7) — date
- approve_date (Field8) — date
- has_air_con (Field9) — bool
- has_fridge (Field10) — bool
- has_washer (Field11) — bool
- has_gas_stove (Field12) — bool
- has_induction (Field13) — bool
- has_microwave (Field14) — bool
- has_desk (Field15) — bool
- has_bed (Field16) — bool
- has_closet (Field17) — bool
- has_shoe_rack (Field18) — bool
- dist_subway (Field19) — int
- dist_pharmacy (Field20) — int
- dist_conv (Field21) — int
- dist_bus (Field22) — int
- dist_mart (Field23) — int
- dist_laundry (Field24) — int
- dist_cafe (Field25) — int
- is_coupang (Field26) — bool
- is_ssg (Field27) — bool
- is_marketkurly (Field28) — bool
- is_baemin (Field29) — bool
- is_yogiyo (Field30) — bool
- is_subway_area (Field31) — bool
- is_convenient_area (Field32) — bool
- is_park_area (Field33) — bool
- is_school_area (Field34) — bool
- options_raw (Field35) — text
- amenities_raw (Field36) — text
- has_sink (Field37) — bool
- has_bookcase (Field38) — bool
item_image_embeddings (임베딩데이터)
- id (PK) — int — Primary key — NOT NULL
- image_id (PK2) — int — Foreign key → item_images.id — NOT NULL
- id (FK) — int — Foreign key → item_images.id — NOT NULL
- id (FK2) — int — Foreign key → item_images.id — NOT NULL
- id (PK3) — int — Foreign key → item_images.id — NOT NULL
- embedding (Field) — vector
- model_name (Field2) — varchar(50)
- created_at (Field3) — timestamp
item_images (매물이미지)
- id (PK) — int — Primary key — NOT NULL
- id (FK) — int — Foreign key → item.item_id — NOT NULL
- id (FK2) — int — Foreign key → item.id — NOT NULL
- id (PK3) — int — Foreign key → item.id — NOT NULL
- s3_url (Field) — text — NOT NULL
- is_main (Field2) — varchar(100)
- created_at (Field3) — timestamp
recent_price (최근가격)
- price_id (PK) — int — Primary key — NOT NULL
- buildyear (Field) — int — NOT NULL
- dealmonth (Field2) — int — NOT NULL
- dealyear (Field3) — int — NOT NULL
- deposit (Field4) — int — NOT NULL
- excluusear (Field5) — int — NOT NULL
- roomfloor (Field6) — int — NOT NULL
- monthlyrent (Field7) — int — NOT NULL
- umdnm (Field8) — int — NOT NULL
- roomclass (Field9) — int — NOT NULL
user (사용자정보)
- user_id (PK) — int — Primary key — NOT NULL
- email (Field) — varchar(100) — NOT NULL
- nickname (Field2) — varchar(50) — NOT NULL
- social_type (Field3) — varchar(20) — NOT NULL
- longitude (Field4) — varchar(100) — NOT NULL
user_item_image (유저생성매물이미지)
- id (PK) — int — Primary key — NOT NULL
- user_id (FK) — int — Foreign key → user.user_id — NOT NULL
- image_url (Field) — text — NOT NULL
- embedding (Field2) — vector
- prompt (Field3) — text
- created_at (Field4) — timestamp