HW2-202320647-김성진

테이블 (3)

AgentOffice

  • agent_id (Key) — 기본 키 — NOT NULL
  • office_address — VARCHAR(200)
  • office_area — VARCHAR(100)
  • office_name — VARCHAR(100)
  • license_number — VARCHAR(50)
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • is_active — BOOLEAN
  • registered_at — DATE
  • note — TEXT

ApartmentComplex

  • complex_id (Key) — 기본 키 — NOT NULL
  • complex_name — VARCHAR(100) — NOT NULL
  • legal_address — VARCHAR(200)
  • road_address — VARCHAR(200)
  • city — VARCHAR(50)
  • main_number — VARCHAR(10)
  • sub_number — VARCHAR(10)
  • build_year — YEAR
  • housing_type — VARCHAR(30)
  • created_at — TIMESTAMP

Transaction

  • transaction_id (Key) — 기본 키 — NOT NULL
  • complex_id (Key2) — 외래 키 → ApartmentComplex.complex_id — NOT NULL
  • agent_id (Key3) — 외래 키 → AgentOffice.agent_id — NOT NULL
  • complex_id — INT — NOT NULL
  • agent_id — INT
  • contract_date — DATE
  • register_date — DATE
  • contract_month — CHAR(6)
  • area_m2 — DECIMAL(6,2)
  • price_krw — INT
  • floor — INT
  • building_number — VARCHAR(10)
  • buyer — VARCHAR(50)
  • seller — VARCHAR(50)
  • cancel_reason — VARCHAR(100)
  • transaction_type — VARCHAR(30)
  • price_per_m2 — INT