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