ssafy

Tables (12)

activity_log

  • id — BIGINT
  • user_id — BIGINT
  • action — VARCHAR(100)
  • detail — TEXT
  • ip_address — VARCHAR(45)
  • created_at — DATETIME

auth_provider

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • provider_name — ENUM('KAKAO', 'NAVER', 'GOOGLE')
  • provider_id — VARCHAR(100) — NOT NULL

board

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • category — ENUM('GENERAL', 'NEWS', 'TIP')
  • view_count — INT
  • created_at — DATETIME
  • updated_at — DATETIME

comment

  • id — BIGINT
  • board_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME

favorites

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • property_id — BIGINT
  • region_id — BIGINT
  • created_at — DATETIME

news

  • id — BIGINT
  • title — VARCHAR(255)
  • link — VARCHAR(255)
  • summary — TEXT
  • source — VARCHAR(100)
  • published_at — DATETIME

notification

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(100)
  • message — TEXT
  • is_read — BOOLEAN
  • created_at — DATETIME

property

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • latitude — DOUBLE
  • longitude — DOUBLE
  • built_year — INT
  • total_units — INT
  • region_id — BIGINT

region

  • id — BIGINT
  • city — VARCHAR(50)
  • district — VARCHAR(50)
  • dong — VARCHAR(50)
  • code — VARCHAR(20)

transaction

  • id — BIGINT
  • property_id — BIGINT — NOT NULL
  • deal_type — ENUM('SALE', 'JEONSE', 'WOLSE') — NOT NULL
  • price — BIGINT — NOT NULL
  • deposit — BIGINT
  • monthly_rent — BIGINT
  • deal_date — DATE
  • area — DECIMAL(5,2)
  • floor — INT

user_settings

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • allow_email — BOOLEAN
  • allow_push — BOOLEAN
  • allow_sms — BOOLEAN
  • two_factor_enabled — BOOLEAN

users

  • id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50)
  • phone — VARCHAR(20)
  • role — ENUM('USER', 'ADMIN')
  • created_at — DATETIME
  • updated_at — DATETIME