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