Teamservice

Tables (9)

crawled_content

  • content_id — NUMBER(10) — Primary key — NOT NULL
  • project_id — NUMBER(10) — Foreign key → project.project_id — NOT NULL
  • title — VARCHAR2(500) — NOT NULL
  • summary — CLOB
  • source_name — VARCHAR2(100)
  • source_url — VARCHAR2(1000) — NOT NULL
  • published_at — TIMESTAMP
  • crawled_at — TIMESTAMP — NOT NULL
  • status — VARCHAR2(20) — NOT NULL

place_favorite

  • favorite_id — NUMBER(10) — Primary key — NOT NULL
  • user_id — NUMBER(10) — Foreign key → users.user_id — NOT NULL
  • place_api_id — VARCHAR2(200) — NOT NULL
  • place_name — VARCHAR2(200) — NOT NULL
  • address — VARCHAR2(500)
  • latitude — NUMBER(10,7)
  • longitude — NUMBER(10,7)
  • created_at — TIMESTAMP — NOT NULL

post

  • post_id — NUMBER(10) — Primary key — NOT NULL
  • project_id — NUMBER(10) — Foreign key → project.project_id — NOT NULL
  • writer_id — NUMBER(10) — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR2(200) — NOT NULL
  • content — CLOB — NOT NULL
  • view_count — NUMBER(10) — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

post_comment

  • comment_id — NUMBER(10) — Primary key — NOT NULL
  • post_id — NUMBER(10) — Foreign key → post.post_id — NOT NULL
  • writer_id — NUMBER(10) — Foreign key → users.user_id — NOT NULL
  • content — CLOB — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

project

  • project_id — NUMBER(10) — Primary key — NOT NULL
  • project_name — VARCHAR2(100) — NOT NULL
  • description — CLOB
  • owner_id — NUMBER(10) — Foreign key → users.user_id — NOT NULL
  • crawl_keyword — VARCHAR2(500)
  • status — VARCHAR2(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

project_member

  • project_member_id — NUMBER(10) — Primary key — NOT NULL
  • project_id — NUMBER(10) — Foreign key → project.project_id — NOT NULL
  • user_id — NUMBER(10) — Foreign key → users.user_id — NOT NULL
  • position — VARCHAR2(20) — NOT NULL
  • member_status — VARCHAR2(20) — NOT NULL
  • invited_by — NUMBER(10) — Foreign key → users.user_id
  • invited_at — TIMESTAMP — NOT NULL
  • responded_at — TIMESTAMP
  • joined_at — TIMESTAMP

project_schedule

  • schedule_id — NUMBER(10) — Primary key — NOT NULL
  • project_id — NUMBER(10) — Foreign key → project.project_id — NOT NULL
  • created_by — NUMBER(10) — Foreign key → users.user_id — NOT NULL
  • schedule_date — DATE — NOT NULL
  • schedule_title — VARCHAR2(200) — NOT NULL
  • schedule_content — VARCHAR2(1000)
  • status — VARCHAR2(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

project_task

  • task_id — NUMBER(10) — Primary key — NOT NULL
  • project_id — NUMBER(10) — Foreign key → project.project_id — NOT NULL
  • assignee_id — NUMBER(10) — Foreign key → users.user_id
  • parent_task_id — NUMBER(10) — Foreign key → project_task.task_id
  • task_title — VARCHAR2(200) — NOT NULL
  • task_content — CLOB
  • task_status — VARCHAR2(20) — NOT NULL
  • progress — NUMBER(3) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • user_id — NUMBER(10) — Primary key — NOT NULL
  • login_id — VARCHAR2(50) — NOT NULL
  • password — VARCHAR2(255) — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • nickname — VARCHAR2(50) — NOT NULL
  • email — VARCHAR2(100) — NOT NULL
  • phone — VARCHAR2(20)
  • status — VARCHAR2(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • withdrawn_at — TIMESTAMP