deukguen
Tables (6)
follow
- no — integer(10) — Primary key — NOT NULL
- email — char(8)
- target_uid — varchar(128)
follwer (follower)
- no — integer(10) — Primary key — NOT NULL — NOT NULL
- email — varchar(128)
- target_uid — varchar(128)
like
- lno — varchar(10) — Primary key — NOT NULL — NOT NULL
- pno — integer(10)
- email — varchar(128)
post
- pid — integer(10) — Primary key — NOT NULL — NOT NULL
- uid — varchar(128) — Primary key — NOT NULL
- image — longblob — server 에 저장 후 경로를 저장
- content — varchar(5000)
- hashtag — varchar(300) — NOT NULL — Allow NULL
- cert3dae — boolean — 3대 인증 글인지 아닌지
rank
- email — varchar(128) — Primary key — NOT NULL
- total — integer(10) — NOT NULL
- deadlift — integer(10) — NOT NULL
- squat — integer(10) — NOT NULL
- benchpress — integer(10) — NOT NULL
userinfo
- uid — varchar(128) — Primary key — NOT NULL — NOT NULL
- email — varchar(128) — Primary key — NOT NULL — NOT NULL
- regitme (regtime) — Date(50)
- password — varchar(128) — NOT NULL
- gender — varchar(5) — NOT NULL