cluster

Tables (6)

Untitled

    article (기사)

    • id — notnull — Primary key — NOT NULL
    • titile (제목) — notnull
    • link (링크) — notnull
    • summary (요약) — null
    • published (기사날짜) — notnull
    • Field

    note (노트)

    • id — notnull — Primary key — NOT NULL
    • title (제목) — notnull
    • text (내용) — null
    • created_at (생성날짜) — notnull
    • updated_at (수정날짜) — notnull
    • user_id — notnull — Foreign key → user.id — NOT NULL

    note_article (노트_기사 매핑)

    • id — notnull — Primary key — NOT NULL
    • created_at (Field) — notnull
    • updated_at (Field2) — notnull
    • state (Field3)
    • note_id — notnull — Foreign key → note.id — NOT NULL
    • article_id — notnull — Foreign key → article.id — NOT NULL

    scrap (스크랩)

    • id — notnull — Primary key — NOT NULL
    • created_at (생성날짜) — notnull
    • updated_at (수정날짜) — notnull
    • state (상태(스크랩중인지)) — notnull
    • article_id — notnull — Foreign key → article.id — NOT NULL
    • user_id — notnull — Foreign key → user.id — NOT NULL

    user (사용자)

    • id — notnull — Primary key — NOT NULL
    • user_name (이름) — notnull
    • emil (이메일) — notnull
    • password (비밀번호) — notnull
    • created_at (생성날짜) — notnull
    • updated_at (수정날짜) — notnull