2차 erd
테이블 (4)
love
- m_no — number
- p_no — NUMBER
member
- m_no — number — 기본 키 — NOT NULL
- m_id — varchar2(100) — NOT NULL
- m_pw — varchar2(100) — NOT NULL
- m_nick — varchar2(100) — NOT NULL
place
- p_no — number — 기본 키 — NOT NULL
- p_name — varchar2(500) — NOT NULL
- p_info — varchar2(4000) — NOT NULL
- p_lati — number(38,30) — NOT NULL
- p_long — number(38,30) — NOT NULL
- p_region — varchar2(100) — NOT NULL
- p_type — varchar2(10) — NOT NULL
reply
- r_no — number — 기본 키 — NOT NULL
- m_no — number — NOT NULL
- r_con — varchar2(1000) — NOT NULL
- p_no — number — NOT NULL
- r_date — date — NOT NULL