My_Instagram

Tables (9)

Comment (comment)

  • comment_id (Key) — int — Primary key — NOT NULL — 댓글아이디
  • content (Field) — varchar(250) — 내용
  • reg_date (Field2) — date — 작성시간
  • like (Field3) — int — 좋아요
  • post_id (Key2) — int — Foreign key → Post.post_id — NOT NULL — 게시물번호
  • parent_id (Field4) — 부모댓글(대댓글용))
  • Key2 (Key22) — Foreign key — NOT NULL

DM_Participant (dm_participant)

  • Key2 (Key22) — Foreign key → User.USER_NO — NOT NULL
  • room_id (Key2) — int — Foreign key → DM_Room.room_id — NOT NULL — 방번호
  • message (Field) — 메시지내용
  • send_at (Field2) — 보낸시간

DM_Room (dm_room)

  • room_id (Key) — int — Primary key — NOT NULL — 방번호
  • created_at (Field4) — date — 생성시간
  • roon_type (Field) — int — 방타입

Follow (follow)

  • Key2 (Key22) — Foreign key → User.USER_NO — NOT NULL
  • reg_date (Field) — date — 날짜
  • Key2 (Key23) — Foreign key → User.USER_NO — NOT NULL

Like (like)

  • comment_id (Key) — int — Foreign key → Comment.comment_id — 댓글아이디
  • post_id (Key2) — int — Foreign key → Post.post_id — 게시물번호
  • Key2 (Key22) — Foreign key → User.USER_NO — NOT NULL

Post (post)

  • post_id (Key) — int — Primary key — NOT NULL — 게시물번호
  • img (Field) — varchar(250) — NOT NULL — 게시물사진
  • description (Field2) — varchar(500) — 게시글
  • reg_date (Field3) — date — 작성시간
  • like (Field4) — int — 좋아요
  • address (Field5) — 장소

Scrap (scrap)

  • post_id (Key2) — int — Foreign key → Post.post_id — NOT NULL — 게시물번호
  • Key2 (Key22) — Foreign key → User.USER_NO — NOT NULL

Tag (Untitled8)

  • post_id (Key) — int — Foreign key → Post.post_id — NOT NULL — 게시물번호
  • Key2 (Key22) — Foreign key → User.USER_NO — NOT NULL

User (users)

  • USER_NO (Key2) — NUMBER — Primary key — NOT NULL — 유저고유식별번호
  • userid (Key) — varchar(50) — NOT NULL — 아이디
  • username (Field) — varchar(50) — NOT NULL — 이름
  • password (Field2) — varchar(100) — NOT NULL — 비밀번호
  • nickname (Field3) — varchar(50) — 닉네임
  • profile_img (Field4) — varchar(250) — 프로필사진
  • reg_date (Field5) — date — NOT NULL — 생성일시
  • description (Field6) — varchar(500) — 프로필'설명
  • verified (Field7) — bit — 인증된사용자(파란딱지)
  • status (Field8) — int — 계정상태
  • email (Field9) — varchar(50) — 이메일