WhiteRabbitRDB
Tables (7)
Comment (댓글)
- Table ID (id) — INT — Primary key — NOT NULL
- Author ID (author) — INT
- Parent ID (parent) — INT
- Content (content) — TEXT
- Comment Time (time) — DATETIME
- Post ID (post) — INT — Foreign key → Post.Table ID — NOT NULL
Follow (팔로우)
- Table ID (id) — INT — Primary key — NOT NULL
- Following User ID (from) — INT — Foreign key → User.Table ID — NOT NULL
- Target User ID (to) — INT — Foreign key → User.Table ID — NOT NULL
Generation (기수)
- Table ID (id) — INT — Primary key — NOT NULL
- Track Name (generation_type) — VARCHAR
- Track Generation (generation_number) — VARCHAR
Like (좋아요)
- Post ID (post_id) — INT — Foreign key → Post.Table ID — NOT NULL
- User ID (user_id) — INT
Post (작성글)
- Table ID (id) — INT — Primary key — NOT NULL
- Title (title) — VARCHAR
- Content (content) — TEXT
- Post View (view_count) — MEDIUMINT
- Post Image (image_url) — VARCHAR
- Post Time (time) — DATETIME
- Author ID (author) — INT — Foreign key → User.Table ID — NOT NULL
- Post Category (category) — INT — Foreign key → Post Category.Table ID — NOT NULL
Post Category (Untitled)
- Table ID (id) — INT — Primary key — NOT NULL
- Group Name (group) — VARCHAR
User (사용자)
- Table ID (id) — INT — Primary key — NOT NULL
- User Name (name) — VARCHAR
- User Email (email) — VARCHAR
- User Password (password) — VARCHAR
- Profile Image URL (profile_url) — VARCHAR
- Coach Authcheck (is_coach) — BOOLEAN
- Admin Authcheck (is_admin) — BOOLEAN
- Join Date (date) — DATE
- User Track (generation) — INT — Foreign key → Generation.Table ID — NOT NULL