ssafy_sns

Tables (18)

alarm

  • alarmcode — int — Primary key — NOT NULL
  • alarm_type — varchar(10) — NOT NULL
  • content — varchar(100) — NOT NULL
  • alarm_check — bit(1)
  • create_date — datetime
  • check_date — datetime
  • feedcode — INT — Foreign key → feed.feedcode — NOT NULL
  • from_email — VARCHAR(40) — Foreign key → user.email — NOT NULL
  • to_email — VARCHAR(40) — Foreign key → user.email — NOT NULL

attendance

  • checkcode — INT — Primary key — NOT NULL
  • start — INT
  • end — INT
  • regtime — TIMESTAMP
  • comment — VARCHAR(100)
  • hobbycode — INT — Foreign key → hobby.hobbycode — NOT NULL
  • email — VARCHAR(40) — Foreign key → hobby.email — NOT NULL

attendanceacc

  • id — INT — Primary key — NOT NULL
  • timetot — INT
  • daytot — INT
  • hobbycode — INT — Foreign key → hobby.hobbycode — NOT NULL

badge

  • badgecode — INT — Primary key — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • hobbycode — INT — Foreign key → hobby.hobbycode
  • email (email2) — VARCHAR(40) — Foreign key → hobby.email — NOT NULL

email_token

  • id — VARCHAR(36) — Primary key — NOT NULL
  • user_email — VARCHAR(40) — Foreign key → user.email — NOT NULL
  • create_date — DATETIME
  • expiration_date — DATETIME
  • expired — BIT(1)
  • last_modified_date — DATETIME

feed

  • feedcode — INT — Primary key — NOT NULL
  • email — VARCHAR(40) — Foreign key → user.email — NOT NULL
  • nickname — VARCHAR(40) — NOT NULL
  • regtime — DATETIME
  • comment — VARCHAR(100)
  • likes — INT
  • scrap — INT
  • tag — VARCHAR(100)

feed_like

  • likecode — INT — Primary key — NOT NULL
  • email — VARCHAR(40) — Foreign key → user.email — NOT NULL
  • feedcode — INT — Foreign key → feed.feedcode — NOT NULL

feedtags

  • id — INT — Primary key — NOT NULL
  • tagcode — INT — Foreign key → tag.tagcode — NOT NULL
  • feedcode — INT — Foreign key → feed.feedcode — NOT NULL

follow

  • followcode — INT — Primary key — NOT NULL
  • from_email — VARCHAR(40) — Foreign key → user.email — NOT NULL
  • to_email — VARCHAR(40) — Foreign key → user.email — NOT NULL

history

  • id — INT — Primary key — NOT NULL
  • email — VARCHAR(40) — Foreign key → user.email — NOT NULL
  • searchword — VARCHAR(40)

hobby

  • hobbycode — INT — Primary key — NOT NULL
  • email (email2) — VARCHAR(40) — Foreign key → user.email — NOT NULL
  • name — VARCHAR(45) — NOT NULL

image

  • imgcode — INT — Primary key — NOT NULL
  • feedcode — INT — Foreign key → feed.feedcode — NOT NULL
  • orgname — VARCHAR(255)
  • newname — VARCHAR(255)
  • imgpath — VARCHAR(255)
  • imgsize — BIGINT — NOT NULL

profile

  • email — VARCHAR(40) — Foreign key → user.email — NOT NULL
  • following — INT
  • follower — INT
  • feeds — INT
  • imgpath — VARCHAR(255)
  • comment — VARCHAR(100)

profile_image

  • email — VARCHAR(40) — Foreign key → user.email — NOT NULL
  • imgname — VARCHAR(255) — NOT NULL
  • content_type — VARCHAR(10) — NOT NULL
  • imgsize — BIGINT — NOT NULL
  • imgpath — VARCHAR(255) — NOT NULL

reply

  • replycode — INT — Primary key — NOT NULL
  • email — VARCHAR(40) — Foreign key → user.email — NOT NULL
  • feedcode — INT — Foreign key → feed.feedcode — NOT NULL
  • nickname — VARCHAR(40) — NOT NULL
  • content — VARCHAR(100) — NOT NULL
  • hide — TINYINT — NOT NULL
  • regtime — datetime

scrap

  • scrapcode — INT — Primary key — NOT NULL
  • feedcode — INT — Foreign key → feed.feedcode — NOT NULL
  • email — VARCHAR(40) — Foreign key → user.email — NOT NULL

tag

  • tagcode — int(11) — Primary key — NOT NULL
  • tagname — varchar(45) — NOT NULL
  • cnt — int(11) — NOT NULL

user

  • email — VARCHAR(40) — Primary key — NOT NULL
  • password — VARCHAR(40) — NOT NULL
  • nickname — VARCHAR(40) — NOT NULL
  • phone — VARCHAR(40) — NOT NULL
  • regdate — DATETIME
  • comment — VARCHAR(100)
  • email_verified — BIT(1) — NOT NULL