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