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