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