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