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) — 이메일