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)