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