N'Visions

Tables (15)

Copy Of Untitled (CopyOfQuestion)

  • Key (q_id) — int — Primary key — NOT NULL
  • Key (s_id) — int — Foreign key → Survey.Key — NOT NULL
  • Field (type_answer) — int — NOT NULL
  • Field2 (title_question_korean) — varchar(100) — NOT NULL
  • Field (title_question_english) — varchar(100) — NOT NULL

Survey

  • Key (s_id) — serial — Primary key — NOT NULL
  • Field3 (date_update) — date — NOT NULL

Untitled (Question)

  • Key (q_id) — int — Primary key — NOT NULL
  • Key (s_id) — int — Foreign key → Survey.Key — NOT NULL
  • Field (type_answer) — int — NOT NULL
  • Field2 (title_question_korean) — varchar(100) — NOT NULL
  • Field (title_question_english) — varchar(100) — NOT NULL

Untitled (TimeAnswer)

  • Key (ta_id) — serial — Primary key — NOT NULL
  • Key (q_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (s_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (time) — time — NOT NULL
  • Field (date) — date — NOT NULL

Untitled (GuestBook)

  • Key (id) — serial — Primary key — NOT NULL
  • Field (url) — varchar(200) — NOT NULL
  • Field2 (date) — date — NOT NULL
  • Field3 (time) — time — NOT NULL
  • Field4 (message) — varchar(500) — NOT NULL
  • Field (blind) — boolean — NOT NULL
  • Field (rd_name) — varchar(10)

Untitled (Admin)

  • Field (url_image_main) — varchar(200) — NOT NULL
  • Field2 (url_image_popup) — varchar(200) — NOT NULL
  • Field (set_popup) — int — NOT NULL
  • Field (name_image_main) — varchar(100) — NOT NULL
  • Field2 (name_image_popup) — varchar(100) — NOT NULL

Untitled (Manager)

  • Key (m_id) — int — Primary key — NOT NULL
  • Field (password) — varchar(30) — NOT NULL

Untitled (Policy)

  • Key (p_id) — serial — Primary key — NOT NULL
  • Field (name) — vartchar(30) — NOT NULL
  • Field (url) — varchar(200)
  • Field (use) — int — NOT NULL
  • Field (file_name) — varchar(200)

Untitled (semiPolicy)

  • Key (sp_id) — serial — Primary key — NOT NULL
  • Key (p_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(100) — NOT NULL
  • Field2 (url) — varchar(200) — NOT NULL

Untitled (submitPolicy)

  • Key (mp_id) — serial — Primary key — NOT NULL
  • Key (p_id2) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (date) — date — NOT NULL
  • Field2 (time) — time — NOT NULL
  • Field (url) — varchar(200) — NOT NULL

Untitled (RateRoadmasterAnswer)

  • Key (rra_id) — serial — Primary key — NOT NULL
  • Key (q_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (s_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (rate) — int
  • Field (date) — date — NOT NULL
  • Field (rd_name) — varchar(10)

Untitled (roadmaster)

  • Key (rd_id) — int — Primary key — NOT NULL
  • Field (rd_name) — varchar(10) — NOT NULL

Untitled2 (RateAnswer)

  • Key (ra_id) — serial — Primary key — NOT NULL
  • Key (q_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (s_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (rate) — int
  • Field (date) — date — NOT NULL

Untitled3 (RateClerkAnswer)

  • Key (rca_id) — serial — Primary key — NOT NULL
  • Key (q_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (s_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (rate) — int
  • Field (date) — date — NOT NULL
  • Field (c_name) — varchar(10)

Untitled4 (Clerk)

  • Key (c_id) — int — Primary key — NOT NULL
  • Field (c_name) — varchar(10) — NOT NULL