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)