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)