umc

Tables (7)

Cert (비번재발급)

  • Key — Primary key — NOT NULL
  • 임시 비밀번호 (Field)
  • 이메일 (Field2)
  • user_id (Field3)

Chatting (채팅)

    JoinTerms (회원가입약관)

    • terms_id (Key) — Primary key — NOT NULL
    • user_id (유저ID) — Foreign key → User.user_id — NOT NULL
    • 약관1 (Field)
    • 약관2 (Field2)
    • 약관3 (Field3)
    • Field4

    Post (글)

    • post_id (글ID) — Primary key — NOT NULL
    • user_id (유저ID) — Foreign key → User.user_id — NOT NULL
    • Field
    • Field2

    Report (신고하기)

    • Key — Primary key — NOT NULL
    • user_id (유저ID) — Foreign key → User.user_id — NOT NULL
    • user_id (유저ID2) — Foreign key → User.user_id — NOT NULL
    • Field
    • Field2

    User (유저)

    • user_id (유저ID) — Primary key — NOT NULL
    • email (Field)
    • univ (Field2)
    • introduction (자기소개)
    • picture (프사)
    • accountId (아이디)
    • password (비밀번호)
    • Field5
    • Field6
    • Field7
    • List<Post> (List<글>)

    comment (댓글)

    • comment_id (댓글_id) — Primary key — NOT NULL
    • user_id (유저ID) — Foreign key → User.user_id — NOT NULL
    • post_id (글ID) — Foreign key → Post.post_id — NOT NULL