sceanestagram

Tables (14)

chat

  • idx — number — Primary key — NOT NULL
  • room_idx — number — Foreign key → chat_room.idx — NOT NULL
  • writer_idx — number — NOT NULL
  • content — varchar2(500)
  • regist_date — date
  • status — varchar2(10)

chat_room

  • idx — number — Primary key — NOT NULL
  • participant1_idx — number — Foreign key → users.idx — NOT NULL
  • participant2_idx — number — Foreign key → users.idx — NOT NULL
  • regist_date — date
  • status — varchar2(10)

comments

  • idx — number — Primary key — NOT NULL
  • users_idx — number — Foreign key → users.idx — NOT NULL
  • parent_idx — number
  • depth — number
  • content — varchar(3000) — NOT NULL
  • regist_date — date
  • status — varchar2(10)

comments_hashtag

  • idx — number — Primary key — NOT NULL
  • comments_idx — number — Foreign key → comments.idx — NOT NULL
  • hashtag_idx — number — Foreign key → hashtag.idx — NOT NULL

comments_users_like

  • idx — number — Primary key — NOT NULL
  • comments_idx — number — Foreign key → comments.idx — NOT NULL
  • users_idx — number — Foreign key → users.idx — NOT NULL

comments_users_tag

  • idx — number — Primary key — NOT NULL
  • comments_idx — number — Foreign key → comments.idx — NOT NULL
  • users_idx — number — Foreign key → users.idx — NOT NULL

follow

  • idx — number — Primary key — NOT NULL
  • follower_idx — number — Foreign key → users.idx — NOT NULL
  • following_idx — number — Foreign key → users.idx — NOT NULL

hashtag

  • idx — number — Primary key — NOT NULL
  • hashtag — varchar2(300) — NOT NULL

image

  • idx — number — Primary key — NOT NULL
  • file_name — varchar2(300) — NOT NULL

post

  • idx — number — Primary key — NOT NULL
  • users_idx — number — Foreign key → users.idx — NOT NULL
  • content — varchar2(3000)
  • location — varchar2(300)
  • regist_date — date
  • status — varchar2(10)
  • views — number

post_hashtag

  • idx — number — Primary key — NOT NULL
  • hashtag_idx — number — Foreign key → hashtag.idx — NOT NULL

post_users_like

  • idx — number — Primary key — NOT NULL
  • users_idx — number — Foreign key → users.idx — NOT NULL

post_users_tag

  • idx — number — Primary key — NOT NULL
  • users_idx — number — Foreign key → users.idx — NOT NULL

users

  • idx — number — Primary key — NOT NULL
  • email — varchar2(500) — NOT NULL
  • pw — varchar2(2000) — NOT NULL
  • gender — varchar2(10)
  • 여성)) — NOT — NOT NULL
  • birth — date — NOT NULL
  • phone_number — varchar2(100) — NOT NULL
  • name — varchar2(100) — NOT NULL
  • nick_name — varchar2(100) — NOT NULL
  • introduce — varchar2(150 char)
  • user_img — varchar2(300)
  • join_date — date
  • status — varchar2(10)