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