develog

Tables (5)

Untitled

    comment (댓글)

    • commentId (comment_id) — Number — Primary key — NOT NULL
    • postId (post_id) — Number — Foreign key → post.postId — NOT NULL
    • nickname — String
    • content — String
    • dateCreated (date_created) — Date

    file (파일)

    • fileId (file_id) — Number — Primary key — NOT NULL
    • postId (post_id) — Number — Foreign key → post.postId — NOT NULL
    • name — string

    post (게시글)

    • postId (post_id) — Number — Primary key — NOT NULL
    • userId (user_id) — Number — Foreign key → user.userId — NOT NULL
    • nickname — String
    • title — String
    • content — String
    • dateCreated (date_created) — Date
    • likedNum — Number

    user (회원)

    • userId (user_id) — Number — Primary key — NOT NULL
    • email — String
    • nickname — String
    • password — String
    • isSocial (is_social) — Boolean
    • postingNum (posting_num) — Number
    • profileImage (profile_image) — String
    • likePost (like_post) — Array