CubeMedical ERD
Tables (6)
cubem_admin
- code — INT(11) — Primary key — NOT NULL
- id — VARCHAR(20) — NOT NULL
- pw — VARCHAR(64) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- register_date — DATETIME — NOT NULL
- update_date — DATETIME — NOT NULL
cubem_board_news
- code — INT(11) — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- contents — LONGTEXT — NOT NULL
- writer — VARCHAR(50) — NOT NULL
- view_cnt — INT(11) — NOT NULL
- register_date — DATETIME — NOT NULL
- update_date — DATETIME — NOT NULL
cubem_gene_info
- code — INT(11) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- gene_name — VARCHAR(255) — NOT NULL
- set1 — VARCHAR(2) — NOT NULL
- set2 — VARCHAR(2) — NOT NULL
- set_normal — INT(2) — NOT NULL
- gene_contents — LONGTEXT — NOT NULL
- gene_test_good — LONGTEXT — NOT NULL
- gene_test_attention — LONGTEXT — NOT NULL
- gene_test_caution — LONGTEXT — NOT NULL
- register_date — DATETIME — NOT NULL
- update_date — DATETIME — NOT NULL
cubem_gene_result
- code — INT(11) — Primary key — NOT NULL
- result — LONGTEXT — NOT NULL
- register_date — DATETIME — NOT NULL
- update_date — DATETIME — NOT NULL
- code (member_code) — INT(11) — Foreign key → cubem_member.code — NOT NULL
cubem_member
- code — INT(11) — Primary key — NOT NULL
- email — VARCHAR(20) — NOT NULL
- pw — VARCHAR(64) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- birth — VARCHAR(8) — NOT NULL
- sex — VARCHAR(2) — NOT NULL
- phone — VARCHAR(11) — NOT NULL
- register_date — DATETIME — NOT NULL
- update_date — DATETIME — NOT NULL
cubem_print_log
- code — INT(11) — Primary key — NOT NULL
- type — VARCHAR(2) — NOT NULL
- searcher_type — INT(2) — NOT NULL
- searcher_code — INT(11) — NOT NULL
- register_date — DATETIME — NOT NULL
- update_date — DATETIME — NOT NULL
- code (member_code) — INT(11) — Foreign key → cubem_member.code — NOT NULL