AICO

Tables (9)

comment

  • cmt_num — INT — Primary key
  • cmt_post — INT — Foreign key → post.post_num
  • cmt_user — INT — Foreign key → user.user_num
  • cmt_detail — VARCHAR2(500)
  • cmt_date — DATE

follow

  • follower — INT — Primary key — NOT NULL
  • user_num — INT — Foreign key → user.user_num — NOT NULL

image

  • img_num — INT — Primary key — NOT NULL
  • img_user — INT — Foreign key → user.user_num — NOT NULL
  • img_name — VARCHAR(200)
  • img_date — DATE
  • img_path — VARCHAR(500)
  • imghash_num — INT — Foreign key → imghashtag.imghash_num — NOT NULL

imghashtag

  • imghash_num — INT — Primary key — NOT NULL
  • title — VARCHAR(15)

likedimg

  • user_num — INT — Foreign key → user.user_num — NOT NULL
  • likedimg_num — INT — Foreign key → image.img_num — NOT NULL

likedpost

  • user_num — INT — Foreign key → user.user_num — NOT NULL
  • post_num — INT — Foreign key → post.post_num — NOT NULL

post

  • post_num — INT — Primary key — NOT NULL
  • post_img — INT — Foreign key → image.img_num — NOT NULL
  • post_likes — INT
  • post_detail — VARCHAR2(500)
  • post_date — DATE

posthashtag

  • post_num — INT — Foreign key → post.post_num — NOT NULL
  • imghash_num — INT — Foreign key → imghashtag.imghash_num — NOT NULL

user

  • user_num — INT — Primary key — NOT NULL
  • user_id — VARCHAR2(200)
  • password — VARCHAR2(200)
  • nickname — VARCHAR2(200) — NOT NULL
  • provider — ENUM(...)
  • snsId — VARCHAR(30)