ss
Tables (11)
catmap
- locationId — bigint — Primary key — NOT NULL
- postId — bigint — Primary key — NOT NULL
comment
- commentId — bigint
- content — tinytext — NOT NULL
- createdAt — datetime(6)
- updatedAt — datetime(6)
- postId — bigint
- userId — varchar(255)
friend
- id — bigint
- friendId — varchar(255)
- status — enum
- userId — varchar(255)
location
- locationId — bigint
- address — varchar(255) — NOT NULL
- latitude — double — NOT NULL
- longitude — double — NOT NULL
- time — time(6)
picture
- pictureId — bigint
- pictureUrl — varchar(255)
- postId — bigint
post
- postId — bigint
- catName — varchar(255)
- commentCnt — bigint
- content — tinytext
- createdAt — datetime(6)
- likeCnt — bigint
- userId — varchar(255)
postlike
- likeId — bigint
- postId — bigint
- userId — varchar(255)
profile
- profileId — bigint
- profileURL — varchar(255)
- userId — varchar(255)
scrap
- scrapId — bigint
- createdAt — datetime(6)
- postId — bigint
- userId — varchar(255)
student
- studentId — bigint
- departmentName — varchar(255)
- schoolName — varchar(255)
- studentName — varchar(255)
- studentNumber — varchar(255)
users
- userId — varchar(255) — NOT NULL
- userAnswer — varchar(255)
- userPassword — varchar(255)
- userPhoneNumber — varchar(255)
- userQuestion — enum
- profileId — bigint
- studentId — bigint