SNS_PROJECT

Tables (7)

Chat

  • chat_id — INT — Primary key
  • user_id — INT — Foreign key → USER.user_id
  • project_id — INT
  • message — TEXT
  • timestamp — TIMESTAMP

Comment

  • comment_id — INT — Primary key
  • created_date — DATE — NOT NULL
  • updated_date — DATE — NOT NULL
  • post_id — INT — Foreign key → Post.post_id
  • user_id — INT — Foreign key → Post.user_id
  • content — TEXT — Foreign key → Post.content — NOT NULL

Post

  • post_id — INT — Primary key
  • content — TEXT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.user_id
  • created_date — DATE — NOT NULL
  • updated_date — DATE — NOT NULL

Project

  • project_name — VARCHAR(255) — NOT NULL
  • create_date — VARCHAR(255) — NOT NULL
  • project_id — INT

ProjectMembers

  • project_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → USER.user_id
  • role — VARCHAR(50) — NOT NULL
  • created_date — VARCHAR(255) — NOT NULL
  • status — VARCHAR(50) — NOT NULL

USER

  • user_id — INT — Primary key
  • user_name — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • created_date — VARCHAR(255) — NOT NULL
  • modified_date — VARCHAR(255) — NOT NULL

friend

  • receiver_id — INT — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • created_date — DATE — NOT NULL
  • updated_date — DATE — NOT NULL
  • friend_id — INT
  • requester_id — INT — NOT NULL