ssafy

Tables (12)

Untitled (dongcode)

  • dongCode — varchar(10) — Primary key — NOT NULL
  • sidoName — varchar(30) — Foreign key → sidocode.sidocode — NOT NULL
  • dongName — varchar(30)

Untitled (houseinfo)

  • apiCode — int — Primary key — NOT NULL
  • dongCode — varchar(10) — Foreign key → Untitled.dongCode — NOT NULL
  • aptName — varchar(50)
  • dongName — varchar(30)
  • buildYear — int
  • jibun — varchar(30)
  • lat — varchar(30)
  • lng — varchar(30)
  • img — varchar(50)

Untitled (housedeal)

  • no — int — Primary key — NOT NULL
  • apiCode — int — Foreign key → Untitled.apiCode — NOT NULL
  • dealAmount — varchar(20)
  • dealYear — int
  • dealMonth — int
  • dealDay — int
  • area — varchar(30)
  • floor — varchar(30)
  • type — varchar(30)
  • rentMoney — varchar(30)

Untitled (baseaddress)

  • no — int — Primary key — NOT NULL
  • dongCode — varchar(10) — Foreign key → Untitled.dongCode — NOT NULL
  • sidoName — varchar(30)
  • gugunName — varchar(30)
  • dongName — varchar(30)
  • lat — varchar(20)
  • lng — varchar(20)

Untitled (member)

  • id — bigint — Primary key — NOT NULL
  • email — varchar(30) — NOT NULL
  • password — varchar(255)
  • username — varchar(20)
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

Untitled (notice)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → Untitled.id — NOT NULL
  • title — varchar(30)
  • body — clob
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

Untitled (question)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → Untitled.id — NOT NULL
  • title — varchar(30)
  • body — clob
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

Untitled (answer)

  • id — bigint — Primary key — NOT NULL
  • question_id — bigint — Foreign key → Untitled.id — NOT NULL
  • member_id — bigint — Foreign key → Untitled.id — NOT NULL
  • title — varchar(30)
  • body — clob
  • created_at — DATETIME
  • updated_at — DATE_TIME
  • deleted_at — DATETIME

Untitled (comment)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → Untitled.id — NOT NULL
  • notice_id — bigint — Foreign key → Untitled.id — NOT NULL
  • body — varchar(255)
  • created_at — DATETIME
  • updated_at — DATETIME
  • deleted_at — DATETIME

Untitled (favorite)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → Untitled.id — NOT NULL
  • notice_id — bigint — Foreign key → Untitled.id — NOT NULL

Untitled (favorited_address)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → Untitled.id — NOT NULL
  • address_no — int — Foreign key → Untitled.no — NOT NULL

sidocode

  • sidocode — varchar(10) — Primary key
  • sidoName — varchar(30)