database basic HM

Tables (9)

categories (카테고리)

  • PK (id) — NUMBER — Primary key — NOT NULL
  • 이름 (name) — VARCHAR2(50)

follows (팔로우)

  • PK (id) — NUMBER — Primary key — NOT NULL
  • FK (user_id) — VARCHAR2(100) — Foreign key → users.PK — NOT NULL
  • FK (user_id1) — VARCHAR2(100)

hashtags (해시태그)

  • PK (id) — NUMBER — Primary key — NOT NULL
  • 이름 (name) — VARCHAR2(50)

likes (좋아요)

  • PK (id) — NUMBER — Primary key — NOT NULL
  • FK (user_id) — NUMBER — Foreign key → users.PK — NOT NULL
  • FK (post_id) — NUMBER — Foreign key → posts.PK — NOT NULL

posts (게시물)

  • PK (id) — NUMBER — Primary key — NOT NULL
  • FK (user_id) — NUMBER — Foreign key → users.PK — NOT NULL
  • FK (category_id) — NUMBER — Foreign key → categories.PK — NOT NULL
  • 제목 (title) — VARCHAR2(200)
  • 내용 (content) — CLOB
  • 생성일자 (create_at) — TIMESTAMP

posts_hashtags (Untitled)

  • PK (id) — NUMBER — Primary key — NOT NULL
  • FK (post_id) — NUMBER — Foreign key → posts.PK — NOT NULL
  • FK (hashtag_id) — NUMBER — Foreign key → hashtags.PK — NOT NULL

reports (신고)

  • PK (id) — NUMBER — Primary key — NOT NULL
  • FK (post_id) — NUMBER — Foreign key → users.PK — NOT NULL
  • FK (user_id) — NUMBER — Foreign key → posts.FK — NOT NULL
  • 신고사유 (reason) — VARCHAR2(255)

users (유저정보)

  • PK (id) — NUMBER — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR2(100)
  • 비밀번호 (password) — VARCHAR2(255)
  • 이름 (name) — VARCHAR2(50)
  • 나이 (age) — NUMBER(3)

views (조회)

  • PK (id) — NUMBER — Primary key — NOT NULL
  • FK (post_id) — NUMBER — Foreign key → users.PK — NOT NULL
  • FK (user_id) — NUMBER — Foreign key → posts.FK — NOT NULL