Argo
Tables (14)
Answer (Untitled2)
- answer_no (Key) — int — Primary key — NOT NULL
- question_no (Key2) — Foreign key → Question.question_no — NOT NULL
- is_correct (Field) — bool
- content (Field2) — varchar2
Board (게시판)
- board_no (Key) — int — Primary key — NOT NULL
- user_no (Key2) — auto — Foreign key → User.user_no — NOT NULL
- title (Field) — VARCHAR(45)
- content (Field2) — VARCHAR(45)
- timestamp (Field3)
Category (카테고리)
- category_no (Key) — int — Primary key — NOT NULL
- category_name (Field)
- classification (Field2)
Comm_History_Sentence (Untitled8)
- sentence_no (Key) — AUTO — Primary key — NOT NULL
- history_no (Key2) — AUTO — Foreign key → Comm_Histroy.history_no — NOT NULL
- speaker (Field) — CHAR(32)
- sentence (Field2) — TEXT
- label_clear (Field3) — INT
- label_concise (Field4) — INT
- label_concrete (Field5) — INT
- label_coherent (Field6) — INT
- label_complete (Field7) — INT
- label_courteous (Field8) — INT
- timestamp (Field9) — DATETIME
Comm_Histroy (Untitled7)
- history_no (Key) — AUTO — Primary key — NOT NULL
- user_no (Key2) — Foreign key → User.user_no — NOT NULL
- title (Field) — CHAR(255)
- code (Field2) — INT
- timestamp (Field3) — DATETIME(AUTO)
- Field4
Comment (댓글)
- comm_no (Key) — int — Primary key — NOT NULL
- board_no (Key2) — int — Foreign key → Board.board_no — NOT NULL
- user_no (Key3) — int — Foreign key → User.user_no — NOT NULL
- content (Field) — VARCHAR(45)
- timestamp (Field2)
Dept (부서)
- dept (Key) — int — Primary key — NOT NULL
- dept_name (Field) — VARCHAR(45)
File (Untitled3)
- file_no (Key) — Primary key — NOT NULL
- board_no (Key2) — int — Foreign key → Board.board_no — NOT NULL
- src (Field)
- name (Field2)
Notice (Untitled5)
- notice_no (Key) — Primary key — NOT NULL
- user_no (Key2) — auto — Foreign key → User.user_no — NOT NULL
- title (Field)
- content (Field2)
- timestamp (Field3)
NoticeFile (Untitled6)
- file_no (Key) — Primary key — NOT NULL
- notice_no (Key2) — Foreign key → Notice.notice_no — NOT NULL
- src (Field)
- name (Field2)
Question (문제)
- question_no (Key) — Primary key — NOT NULL
- category_no (Key2) — int — Foreign key → Category.category_no — NOT NULL
- content (Field)
Result (푼 결과)
- result_no (Key) — Primary key — NOT NULL
- user_no (Key2) — auto — Foreign key → User.user_no — NOT NULL
- question_no (Key4) — Foreign key → Question.question_no — NOT NULL
- answer_no (Key3) — Foreign key → Answer.answer_no — NOT NULL
- timestamp (Field)
- is_correct (Field2) — bool
- content (Field3)
User (Untitled)
- user_no (Key) — auto — Primary key — NOT NULL
- dept (Key2) — int — Foreign key → Dept.dept — NOT NULL
- id (Field6)
- name (Field2) — VARCHAR(20)
- password (Field) — VARCHAR(128)
- email (Field3) — VARCHAR(254)
- phone (Field5) — VARCHAR
- is_admin (Field4) — bool
- image (Field7)
chat_session (Untitled4)
- id (Key) — Primary key — NOT NULL
- session_title (Field)
- chat_content (Field3)
- user_no (Key2) — auto — Foreign key → User.user_no — NOT NULL