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