중방
테이블 (3)
building
- idx — BIGINT(20) — 기본 키 — NOT NULL
- modify_date — DATETIME(6)
- register_date — DATETIME(6)
- address1 — VARCHAR(255)
- address2 — VARCHAR(255)
- auth_type — INT(11) — NOT NULL
- building_type — INT(11) — NOT NULL
- deposit — INT(11)
- maintenance_fee — INT(11)
- memo — VARCHAR(255)
- owner_name — VARCHAR(255)
- owner_phone — VARCHAR(255)
- price — INT(11)
- rent_type — INT(11) — NOT NULL
- rental_fee — INT(11)
- sms_term — INT(11) — NOT NULL
- use_yn — INT(11) — NOT NULL
- member_idx — BIGINT(20)
- premium — INT(11)
- code — VARCHAR(45) — NOT NULL
- building_state — INT(11) — NOT NULL
- price_update_state — VARCHAR(45) — NOT NULL
- latest_send_sms_date — DATETIME(6)
- notice_type — INT(1)
- no — INT(11) — NOT NULL
- INDEX — `FK7id2not0w6m090lgw1c1lm6fl`
member
- idx — BIGINT(20) — 기본 키 — NOT NULL
- modify_date — DATETIME(6)
- register_date — DATETIME(6)
- auth — VARCHAR(100) — NOT NULL
- id — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- phone — VARCHAR(100) — NOT NULL
- use_yn — INT(11) — NOT NULL
- company — VARCHAR(45)
sms
- idx — BIGINT(20) — 기본 키 — NOT NULL
- modify_date — DATETIME(6)
- register_date — DATETIME(6)
- building_idx — BIGINT(20) — NOT NULL
- member_idx — BIGINT(20) — NOT NULL
- message — VARCHAR(45)
- owner_name — VARCHAR(100) — NOT NULL
- owner_phone — VARCHAR(100) — NOT NULL
- reply_yn — INT(1)
- reply_type — INT(1)
- reply_date — DATETIME(6)
- type — INT(1) — NOT NULL
- message_id — VARCHAR(45)
- status_code — VARCHAR(10)
- group_id — VARCHAR(45)
- INDEX — `FK7nnd7dt8ju4vmtcltasgfu6fv`
- INDEX — `FKeun69n7psrc1c8l4ae91hyj3q`