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