살래

테이블 (12)

거래 (Contract)

  • contract_id (Key) — int — 기본 키 — NOT NULL
  • user_id (Key2) — int — 외래 키 → 회원.user_id — NOT NULL
  • product_id (Key3) — int — 외래 키 → 매물.product_id — NOT NULL
  • price (Field4) — int
  • contract_status (Field) — varchar(20)
  • account (Field2) — varchar(30)

게시판 (Board)

  • board_id (Key) — int — 기본 키 — NOT NULL
  • user_id (Key2) — int — 외래 키 → 회원.user_id — NOT NULL
  • board_content (Field) — varchar(200)

게시판 댓글 (Comment)

  • comment_id (Key) — int — 기본 키 — NOT NULL
  • user_id (Key2) — int — 외래 키 → 회원.user_id — NOT NULL
  • board_id (Key3) — int — 외래 키 → 게시판.board_id — NOT NULL
  • user_id (Key4) — int — 외래 키 → 게시판.user_id — NOT NULL
  • comment_content (Field) — varchar(100)

매물 (Product)

  • product_id (Key) — int — 기본 키 — NOT NULL
  • user_id (Key2) — int — 외래 키 → 회원.user_id — NOT NULL
  • region_id (Key3) — int — 외래 키 → 지역.region_id — NOT NULL
  • product_name (Field8) — varchar(50)
  • payment_type (Field) — varchar(20) — 전/월세
  • address (Field2) — varchar(50) — 서울시 마포구 연남동 234-12동
  • address_detail (Field4) — varchar(20)
  • deposit (Field5) — int
  • rentfee (Field6) — int
  • area (Field7) — double
  • product_type (Field3) — varchar(20)
  • floor (Field9) — int
  • enter_day (Field10) — date
  • room_count (Field11) — int
  • bath_count (Field12) — int
  • approve_day (Field13) — date
  • park_count (Field14) — int
  • manage_fee (Field15) — int
  • direction (Field16) — varchar(20)
  • view_count (Field17) — int
  • product_status (Field19) — varchar(20)

신고 (Report)

  • user_id (Key2) — int — 외래 키 → 회원.user_id — NOT NULL
  • product_id (Key) — int — 외래 키 → 매물.product_id — NOT NULL
  • report_content (Field) — varchar(500)

전자계약서 (E_Contract)

  • econtract_id (Key) — int — 기본 키 — NOT NULL
  • product_id (Key2) — int — 외래 키 → 매물.product_id — NOT NULL
  • contract_id (Key3) — int — 외래 키 → 거래.contract_id — NOT NULL
  • contract_startdate (Field) — date
  • contract_enddate (Field2) — date
  • contract_date (Field3) — date
  • contract_rule (Field4) — varchar(200)

좋아요 ! (Like)

  • id (Key) — 기본 키 — NOT NULL
  • product_id (Key3) — int — 외래 키 → 매물.product_id — NOT NULL
  • user_id (Key2) — int — 외래 키 → 회원.user_id — NOT NULL
  • is_liked (Field2) — boolean

지역 (Region)

  • region_id (Key2) — int — 기본 키 — NOT NULL
  • province (Field) — varchar(50)

채팅 상세 (Chat)

  • chat_id (Key) — int — 기본 키 — NOT NULL
  • contract_id (Key22) — int — 외래 키 → 채팅방.contract_id — NOT NULL
  • content (Field) — varchar(500)
  • send_time (Field2) — timestamp
  • is_check (Field3) — boolean

채팅방 (ChatRoom)

  • contract_id (Key2) — int — 외래 키 → 거래.contract_id — NOT NULL
  • name (Field3) — varchar(50)
  • created_at (Field) — timestamp
  • updated_at (Field2) — timestamp

판매자 평점 (Review)

  • review_id (Key) — int — 기본 키 — NOT NULL
  • user_id (Key2) — int — 외래 키 → 회원.user_id — NOT NULL
  • review_rate (Field) — int
  • review_content (Field2) — varchar(200)

회원 (User)

  • user_id (Key) — int — 기본 키 — NOT NULL
  • id (Field3) — varchar(30)
  • password (Field) — varchar(30)
  • auth_seller (Field2) — boolean — 배지
  • phone_num (Field5) — varchar(20)
  • user_name (Field6) — varchar(20)
  • resident_num (Field7) — varchar(30)
  • address (Field8) — varchar(50)
  • address_detail (Field9) — varchar(20)
  • email (Field4) — email