InoT

Tables (5)

board

  • Key (board_num) — int — Primary key — NOT NULL
  • Field (board_title) — varchar(200)
  • Field (board_content) — longblob
  • Field (board_writer) — varchar(200)
  • Field (board_regdate) — timestamp
  • Field (board_count) — bigint
  • Key (mem_num) — int — Foreign key → member.Key — NOT NULL

chart

  • Key (chart_num) — int — Primary key — NOT NULL
  • Field (chart_date) — timestamp
  • Field (chart_today) — bigint
  • Field (contact_total) — bigint

contact

  • Key (contact_num) — int — Primary key — NOT NULL
  • Field (contact_type) — varchar(200)
  • Field (contact_name) — varchar(200)
  • Field (contact_phone) — varchar(200)
  • Field (contact_email) — varchar(200)
  • Field (contact_budget) — varchar(200)
  • Field (contact_req) — longblob

file

  • Key (file_num) — int — Primary key — NOT NULL
  • Field (file_name) — longblob
  • Field (file_uuid) — longblob
  • Field (file_size) — varchar(200)
  • Field (file_extension) — varchar(200)
  • Field (file_location) — longblob
  • Key (board_num) — int — Foreign key → board.Key — NOT NULL

member

  • Key (mem_num) — int — Primary key — NOT NULL
  • Field (mem_name) — varchar(200)
  • Field (mem_id) — varchar(200)
  • Field (mem_pw) — varchar(200)
  • Field (mem_email) — varchar(200)
  • Field (mem_phone) — varchar(200)
  • Field (mem_role) — varchar(200)
  • Field (mem_status) — varchar(200)