청약정보조회

테이블 (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