동아리커뮤니티

테이블 (9)

Club (동아리)

  • Key — 기본 키 — NOT NULL
  • Field

Comment (댓글)

  • id (COMMENT_ID) — BIGINT — 기본 키 — NOT NULL
  • comment_text (Field3) — VARCHAR(100)
  • created_at (Field4) — TIMESTAMP
  • updated_at (Field5) — TIMESTAMP
  • ID (USER_ID) — BIGINT — NOT NULL
  • ID (POST_ID) — BIGINT — NOT NULL

GeneralPost (Untitled)

  • Key — 기본 키 — NOT NULL
  • Field

POSTS (게시글)

  • ID (POST_ID) — BIGINT — 기본 키 — NOT NULL
  • Title (Field1) — VARCHAR(255)
  • Content (Field2) — VARCHAR(500)
  • Created_At (Field3) — TIMESTAMP
  • Updated_At (Field4) — TIMESTAMP
  • View_Count (Field5) — INTEGER
  • Like_Count (Field6) — INTEGER
  • ID (USER_ID) — BIGINT — NOT NULL
  • Id (CLIMBING_GYM_ID) — BIGINT — NOT NULL

PROFILE_IMAGES (프로필 이미지)

  • ID (PROFILE_IMAGES_ID) — BIGINT — 기본 키 — NOT NULL
  • PATH (Field) — VARCHAR(512)

PromotePost (Untitled2)

  • Key — 기본 키 — NOT NULL
  • Field

Refresh_Tocken (리프레쉬토큰)

  • Id (REFRESH_TOCKEN_ID) — BIGINT — 기본 키 — NOT NULL
  • Value (Field) — VARCHAR(255)
  • ID (USER_ID) — BIGINT — NOT NULL

USERS (유저)

  • ID (USER_ID) — BIGINT — 기본 키 — NOT NULL
  • USERNAME (Field) — VARCHAR(20)
  • PASSWORD (Field2) — VARCHAR(50)
  • NAME (Field3) — VARCHAR(20)
  • EMAIL (Field4) — VARCHAR(50)
  • ADDRESS (Field5) — VARCHAR(255)
  • PHONENUMBER (Field6) — VARCHAR(50)
  • GENDER (Field7) — BOOL
  • ID (PROFILE_IMAGES_ID) — BIGINT — NOT NULL

USER_POST_LIKES (좋아요)

  • ID (USER_LIKE_ID) — BIGINT — 기본 키 — NOT NULL
  • ID (USER_ID) — BIGINT — NOT NULL
  • ID (POST_ID) — BIGINT — NOT NULL