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