SSAFY_SNS

Tables (16)

badge

  • badgecode — INT — Primary key — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • hobbycode — INT — Foreign key → hobby.hobbycode
  • INDEX — `fk_badge_hobbycode_idx`

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
  • INDEX — `fk_token_email_idx`

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
  • INDEX — `fk_feed_email_idx`

feed_like

  • code — INT — Primary key — NOT NULL
  • email — VARCHAR(40) — Foreign key → user.email — NOT NULL
  • feedcode — INT — Foreign key → feed.feedcode — NOT NULL
  • INDEX — `fk_like_feedcode_idx`
  • INDEX — `fk_like_email_idx`

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) — NOT NULL
  • searchword — VARCHAR(40) — NOT NULL

hobby

  • hobbycode — INT — Primary key — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • email — VARCHAR(45) — Foreign key → user.email
  • INDEX — `fk_hobby_email_idx`

image

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

notifiication

  • email — VARCHAR(40) — Foreign key → user.email — NOT NULL
  • requestcode — INT — Foreign key → request.requestcode — NOT NULL
  • create_date — DATETIME
  • INDEX — `fk_notification_email_idx`
  • INDEX — `fk_notification_requestcode_idx`

profile

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

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
  • INDEX — `fk_profile_image_email_idx`

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
  • INDEX — `fk_reply_email_idx`
  • INDEX — `fk_reply_feedcode_idx`

request

  • requestcode — INT — Primary key — NOT NULL
  • type — VARCHAR(40) — NOT NULL
  • content — VARCHAR(100) — NOT NULL
  • datetime — DATETIME — NOT NULL

scrap

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

tags

  • 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