t
Tables (11)
Untitled
- 사원번호 (Key) — Primary key — NOT NULL
- Field
- Field2
- Field3
Untitled2
- 부서번호 (Key) — Primary key — NOT NULL
- 부서명 (Field)
- Field2
comments
- id — NUMBER
- post_id — NUMBER — Foreign key → posts.id — NOT NULL
- user_id — NUMBER — Foreign key → users.id — NOT NULL
- parent_id — NUMBER — Foreign key → comments.id
- content — VARCHAR2(1000) — NOT NULL
- is_deleted — CHAR(1)
- created_at — DATE
files
- id — NUMBER
- post_id — NUMBER — Foreign key → posts.id
- file_name — VARCHAR2(255)
- file_path — VARCHAR2(500)
- file_size — NUMBER
- created_at — DATE
post_likes
- user_id — NUMBER — Foreign key → users.id — NOT NULL
- post_id — NUMBER — Foreign key → posts.id — NOT NULL
- created_at — DATE
post_tags
- post_id — NUMBER — Foreign key → posts.id — NOT NULL
- tag_id — NUMBER — Foreign key → tags.id — NOT NULL
posts
- id — NUMBER
- user_id — NUMBER — Foreign key → users.id — NOT NULL
- title — VARCHAR2(255) — NOT NULL
- content — CLOB — NOT NULL
- view_count — NUMBER
- like_count — NUMBER
- is_deleted — CHAR(1)
- created_at — DATE
- updated_at — DATE
roles
- id — NUMBER
- name — VARCHAR2(30) — NOT NULL
tags
- id — NUMBER
- name — VARCHAR2(50) — NOT NULL
user_roles
- user_id — NUMBER — Foreign key → users.id — NOT NULL
- role_id — NUMBER — Foreign key → roles.id — NOT NULL
users
- id — NUMBER
- username — VARCHAR2(50) — NOT NULL
- password — VARCHAR2(255) — NOT NULL
- email — VARCHAR2(100)
- status — VARCHAR2(20)
- created_at — DATE