SALT_정규화
테이블 (6)
admin
- admin_id — VARCHAR(128) — 기본 키 — NOT NULL
- admin_password — VARCHAR(128) — NOT NULL
- admin_name — VARCHAR(16)
- admin_nickname — VARCHAR(16)
- admin_email — VARCHAR(128)
board
- board_id — INT — 기본 키 — NOT NULL
- main_category_name — VARCHAR(16) — 외래 키 → sub_category.main_category_name — NOT NULL
- sub_category_name — VARCHAR(16) — 외래 키 → sub_category.sub_category_name — NOT NULL
- user_id — VARCHAR(128) — 외래 키 → user.user_id
- admin_id — VARCHAR(128) — 외래 키 → admin.admin_id
- board_title — VARCHAR(64) — NOT NULL
- board_content — TEXT
- board_generate_day — TIMESTAMP
- board_viewcount — INT — NOT NULL
board_image
- board_image_no — INT — 기본 키 — NOT NULL
- board_id — INT — 외래 키 → board.board_id — NOT NULL
- board_image_url — VARCHAR(128) — NOT NULL
main_category
- main_category_name — VARCHAR(16) — 기본 키 — NOT NULL
sub_category
- sub_category_name — VARCHAR(16) — 기본 키 — NOT NULL
- main_category_name — VARCHAR(16) — 외래 키 → main_category.main_category_name — NOT NULL
user
- user_id — VARCHAR(128) — 기본 키 — NOT NULL
- user_name — VARCHAR(16)
- user_cellphone — VARCHAR(128)
- user_email — VARCHAR(128)
- nickname — VARCHAR(16)
- register_date — TIMESTAMP
- user_update_date — TIMESTAMP
- user_password — VARCHAR(128) — NOT NULL