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