bigproject

Tables (10)

Untitled

    article

    • id — INT — Primary key — NOT NULL
    • user_id — INT — Foreign key → user.id — NOT NULL
    • category_id — INT — Foreign key → category.id — NOT NULL
    • title — VARCHAR(100)
    • body — TEXT
    • content_file — VARCHAR(255)
    • view — BIGINT
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP

    category

    • id — INT — Primary key — NOT NULL
    • major — VARCHAR(30)
    • sub — VARCHAR(30)

    chat_message

    • id — INT — Primary key — NOT NULL
    • chat_room_id — INT — Foreign key → chat_room.id — NOT NULL
    • message_id — INT — NOT NULL
    • input — TEXT — NOT NULL
    • output — TEXT — NOT NULL
    • timestamp — TIMESTAMP

    chat_room

    • id — INT — Primary key — NOT NULL
    • user_id — INT — Foreign key → user.id — NOT NULL
    • room_name — VARCHAR(50) — NOT NULL
    • created_at — TIMESTAMP

    comment

    • id — INT — Primary key — NOT NULL
    • post_id — INT — Foreign key → article.id — NOT NULL
    • user_id — INT — Foreign key → user.id — NOT NULL
    • comment_text — VARCHAR(200)
    • created_at — TIMESTAMP

    file

    • id — INT — Primary key — NOT NULL
    • post_id — INT — Foreign key → article.id — NOT NULL
    • name — VARCHAR(255)
    • path — VARCHAR(255)
    • width — INT
    • height — INT
    • byte_size — INT

    glossary

    • id — INT — Primary key — NOT NULL
    • word — VARCHAR(50)
    • description — TEXT
    • view — BIGINT

    law_data

    • id — INT — Primary key — NOT NULL
    • nation — VARCHAR(48)
    • category — VARCHAR(30)
    • body — TEXT
    • view — BIGINT

    user

    • id — INT — Primary key — NOT NULL
    • uuid — CHAR(36) — NOT NULL
    • username — VARCHAR(50)
    • password — VARCHAR(50) — NOT NULL
    • email — VARCHAR(100) — NOT NULL
    • nickname — VARCHAR(20)
    • nationality — VARCHAR(50) — NOT NULL
    • created_at — TIMESTAMP
    • updated_at — TIMESTAMP