ex1

테이블 (4)

Untitled

    building_units

    • unit_id — CHAR(5) — NOT NULL
    • building_dong — VARCHAR(10) — NOT NULL
    • building_ho — VARCHAR(10) — NOT NULL
    • unit_type — VARCHAR(20)
    • is_available — TINYINT(1)
    • created_at — TIMESTAMP

    terms

    • term_id — CHAR(4) — NOT NULL
    • term_type — VARCHAR(20) — NOT NULL
    • title — VARCHAR(200) — NOT NULL
    • content — LONGTEXT — NOT NULL
    • version — VARCHAR(10) — NOT NULL
    • is_active — TINYINT(1)
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP

    유저 (Users)

    • USER (user_id) — CHAR(4) — 기본 키 — NOT NULL
    • Email (email_id)
    • Field2
    • Field
    • Field3