BBBot
Tables (13)
bbb_ question
- PK (id) — int — Primary key — NOT NULL
- Field (title) — varchar
- Field (content) — text
- Field (date) — date
- Field (token_count) — int
bbb_answer
- FK (id) — int — Foreign key → bbb_ question.PK — NOT NULL
- Field (comment) — text
- Field (summary) — text
bbb_comment
- FK (id) — int — Foreign key → bbb_ question.PK — NOT NULL
- Field (comment) — text
bbb_search
- Field (word) — varchar
- Field (search_id) — text
chat_log
- PK (c_id) — int — Primary key — NOT NULL
- FK (member_code) — int — Foreign key → member.PK — NOT NULL
- Field (query) — text
- Field (log_time) — timestamp
- Field (word_token) — text
facility
- PK (f_code) — int — Primary key — NOT NULL
- Field (place_name) — varchar
- Field (type) — varchar
- Field (address) — varchar
- Field (district) — varchar
- Field (lon) — float
- Field (lat) — float
faq_board
- PK (no) — int — Primary key — NOT NULL
- Field (title) — varchar
- Field (answer) — text
- Field (count) — int
member
- PK (member_code) — int — Primary key — NOT NULL
- Field (id) — varchar
- Field (password) — varchar
- Field (residence) — varchar
member_child
- FK (member_code) — int — Foreign key → member.PK — NOT NULL
- Field (gender) — int
- Field (birth) — date
product
- PK (p_code) — int — Primary key — NOT NULL
- Field (name) — varchar
- Field (tag) — varchar
wellness
- PK (resource) — varchar — Primary key — NOT NULL
- Field (label) — varchar
wellness_pro
- FK (resource) — varchar — Foreign key → wellness.PK — NOT NULL
- Field (property) — varchar
- Field (descript) — varchar
wellness_sym
- FK (resource) — varchar — Foreign key → wellness.PK — NOT NULL
- Field (symptom_area) — varchar