청약정보조회
테이블 (3)
APT (Untitled4)
- a_name (Key) — VARCHAR(50) — 기본 키 — NOT NULL
- s_date (Field) — INT(8)
- m_date (Field2) — INT(8)
- company (Field3) — VARCHAR(50)
- url (Field4) — VARCHAR(300)
- restriction (Field5) — CHAR(1)
- price (Field6) — INT(15)
- s_rooms (Field7) — INT(15)
- address (Field8) — VARCHAR(100)
CUSTOMER (Untitled)
- c_id (Key) — VARCHAR(10) — 기본 키 — NOT NULL
- budget (Field) — INT(15)
- point (Field2) — INT(2)
- dimension (Field3) — INT(3)
- c_type (Field4) — VARCHAR(20)
INFO (Untitled2)
- like (Key) — INT(100) — 기본 키 — NOT NULL
- c_id (Key2) — VARCHAR(10) — 외래 키 → CUSTOMER.c_id — NOT NULL
- a_name (Key3) — VARCHAR(50) — 외래 키 → APT.a_name — NOT NULL