instargram

Tables (7)

CONTENT

  • content_id — Primary key
  • writer_id — INT — Foreign key → USER.id — NOT NULL — USER테이블의 식별자 이며 SEQUNCE에 의해 자동생성
  • content
  • modified_at
  • created_at

DM

  • dm_id — INT — Primary key — NOT NULL
  • chatroom_id — INT — Foreign key → chatroom.chatroom_id — NOT NULL
  • participant_id — INT — Foreign key → USER.id — NOT NULL — USER테이블의 식별자 이며 SEQUNCE에 의해 자동생성
  • modified_at
  • created_at

FLLOW

  • fllow_id — Primary key — NOT NULL
  • following_id (user_id) — INT — Foreign key → USER.id — NOT NULL — USER테이블의 식별자 이며 SEQUNCE에 의해 자동생성
  • follower_id — INT — Foreign key → USER.id — NOT NULL — USER테이블의 식별자 이며 SEQUNCE에 의해 자동생성
  • modified_at
  • created_at

MEDIA

  • media_id — Primary key — NOT NULL
  • content_id — Foreign key → CONTENT.content_id
  • file_name
  • created_at

REPLY

  • reply_id — Primary key — NOT NULL
  • content_id — Foreign key → CONTENT.content_id
  • writer_id — INT — Foreign key → USER.id — NOT NULL — USER테이블의 식별자 이며 SEQUNCE에 의해 자동생성
  • reply
  • modified_at
  • created_at

USER

  • id (user_id) — INT — Primary key — NOT NULL — USER테이블의 식별자 이며 SEQUNCE에 의해 자동생성
  • user_name — NOT NULL
  • password
  • profileImageUrl (profile_image_url)
  • role
  • createAt (create_at)
  • modifiedAt (modified_at)

chatroom (Untitled)

  • chatroom_id — INT — Primary key — NOT NULL
  • last_particpant_name
  • last_message
  • modified_at
  • created_at