DSE
Tables (9)
Category (카테고리)
- Field
- Field2
- Field3
- Field4
- Field5
Follow (팔로우)
- Uid (follower_id) — int(10) — Foreign key → User.Uid — NOT NULL
- Uid (following_id) — int(10) — Foreign key → User.Uid — NOT NULL
Hashtag (해쉬태그)
- Hid (hid) — int(10) — Primary key — NOT NULL
- Title (title) — varchar(128)
Like (좋아요)
- Uid (uid) — int(10) — Foreign key → User.Uid — NOT NULL
- Pid (pid) — int(10) — Foreign key → Post.Pid — NOT NULL
Post (게시글)
- Pid (pid) — int(10) — Primary key — NOT NULL
- Uid (uid) — int(10) — Foreign key → User.Uid — NOT NULL
- Title (title) — varchar(128)
- Contents (contents) — varchar(5000)
- Hit (hit) — int(10)
- Is_hidden (is_hidden) — Boolean
- Create_date (create_date) — datetime
- Is_complete (is_complete) — Boolean
Post-Hashtag (연결)
- Pid (pid) — int(10) — Foreign key → Post.Pid — NOT NULL
- Hid (hid) — int(10) — Foreign key → Hashtag.Hid — NOT NULL
Recommand (추천)
- Uid (uid) — int(10) — Foreign key → User.Uid — NOT NULL
- Pid (pid) — int(10) — Foreign key → Post.Pid — NOT NULL
- Count (count) — int(10)
Reply (댓글)
- Rid (rid) — int(10) — Primary key — NOT NULL
- Pid (pid) — int(10) — Foreign key → Post.Pid — NOT NULL
- Uid (uid) — int(10) — Foreign key → User.Uid — NOT NULL
- Is_hidden (is_hidden) — Boolean
- Create_date (create_date) — datetime
- Reply (reply) — varchar(2000)
User (회원)
- Uid (uid) — int(10) — Primary key — NOT NULL
- Uid (following_id) — int(10) — Foreign key → Follow.Uid — NOT NULL
- Email (email) — varchar(128)
- Passwrod (password) — varchar(128)
- Create_date (create_date) — datetime
- Role (role) — int(2)
- Nickname (nickname) — varchar(24)
- Provider (provider) — varchar(10)
- SNSId (snsid) — varchar(30)