instagram
Tables (7)
comment (댓글)
- comment_id (Key4) — int — Primary key — NOT NULL
- post_id (Key) — int — Foreign key → post.post_id — NOT NULL
- user_id (Key2) — nvarchar2(20) — Foreign key → user.user_id — NOT NULL
- comment (Field) — nvarchar2(500)
- create_at (Field2) — DATE
- update_at (Field3) — DATE
- status (Field4) — char
- comment_id (Key42) — int — Foreign key → comment.comment_id — NOT NULL
friend (친구)
- side_user_id (Key2) — nvarchar2(20) — Primary key — NOT NULL
- user_id (Key3) — nvarchar2(20) — Foreign key → user.user_id — NOT NULL
- create_at (Field) — DATE
- status (Field2) — char
image (이미지)
- image_id (Key) — int — Primary key — NOT NULL
- post_id (Key22) — int — Foreign key → post.user_id — NOT NULL
- image_file_name (Field) — nvarchar2(400)
like_comment (댓글좋아요)
- comment_id (Key4) — int — Foreign key → comment.comment_id — NOT NULL
- user_id (Key22) — nvarchar2(20) — Foreign key → comment.user_id — NOT NULL
- create_at (Field) — DATE
- status (Field2) — char
like_post (게시글좋아요)
- post_id (Key2) — int — Foreign key → post.post_id — NOT NULL
- user_id (Key3) — nvarchar2(20) — Foreign key → user.user_id — NOT NULL
- create_at (Field) — DATE
- status (Field2) — char
post (게시글)
- post_id (Key) — int — Primary key — NOT NULL
- user_id (Key2) — nvarchar2(20) — Foreign key → user.user_id — NOT NULL
- post_text (Field) — nvarchar2(200)
- create_at (Field2) — DATE
- update_at (Field3) — DATE
- status (Field4) — char
user (사용자)
- user_id (Key) — nvarchar2(20) — Primary key — NOT NULL
- email (Field) — nvarchar2(30)
- password (Field2) — nvarchar2(20)
- name (Field3) — nvarchar2(10)
- phone_number (Field4) — nvarchar2(13)
- create_at (Field5) — DATE
- update_at (Field6) — DATE
- status (Field7) — char