kids

Tables (10)

comment (댓글)

  • comment_id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → post.post_id — NOT NULL
  • user_id (Field)

community (커뮤니티)

  • Key — Primary key — NOT NULL

community_roles (커뮤_권한)

  • Key — Primary key — NOT NULL

file (파일)

    like (Untitled3)

    • id (Key2) — Primary key — NOT NULL
    • post_id (Key) — Foreign key → post.post_id — NOT NULL
    • user_id (Field)

    members (Untitled2)

    • Key — Primary key — NOT NULL
    • Field

    post (게시글)

    • post_id (Key) — Primary key — NOT NULL
    • title (Field4)
    • contents (Field5)
    • comment_count (Field)
    • like_count (Field2)
    • author_id (Field3)

    post_file (Untitled)

    • id (Key) — Primary key — NOT NULL
    • file_id (Field2)
    • post_id (Key2) — Foreign key → post.post_id — NOT NULL

    school_roles (스쿨_권한)

    • id (Key) — Primary key — NOT NULL
    • Field
    • Field2

    schools (스쿨)

    • id (아이디) — Primary key — NOT NULL
    • Key — Primary key — NOT NULL
    • name (이름)
    • address (주소)