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