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