동아리커뮤니티
테이블 (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