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