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