COOZ

테이블 (6)

게시판 (board)

  • board_id — INT — 기본 키 — NOT NULL
  • shop_id — VARCHAR(50) — 외래 키 → 소상공인.shop_id — NOT NULL
  • title — VARCHAR(50)
  • contents — longtext
  • created_datetime — DATETIME
  • updated_datetime — DATETIME
  • hits — INT

댓글 (comments)

  • comments_id — INT — 기본 키 — NOT NULL
  • user_id — VARCHAR(20) — 외래 키 → 사용자.user_id — NOT NULL
  • board_id — INT — 외래 키 → 게시판.board_id — NOT NULL
  • shop_id — VARCHAR(50) — 외래 키 → 게시판.shop_id — NOT NULL
  • comments_group — INT
  • comments (Field) — VARCHAR(255)
  • comments_level — INT
  • status — ENUM('visible','hidden','update')
  • comments_time — DATETIME

사용자 (users)

  • user_id — VARCHAR(20) — 기본 키 — NOT NULL
  • pw — VARCHAR(255)
  • email — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(30)
  • role — ENUM('user','merchant','admin') — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • pw_salt — VARCHAR(255)
  • nickname — VARCHAR(50)
  • profile_image (progile_image) — longtext

소상공인 (merchants)

  • shop_id — VARCHAR(50) — 기본 키 — NOT NULL
  • pw — VARCHAR(255)
  • email — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(30)
  • role — ENUM('user','merchant','admin') — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • pw_salt — VARCHAR(255)
  • nickname — VARCHAR(50)
  • profile_image (progile_image) — longtext
  • shop_name — VARCHAR(50)
  • address — VARCHAR(255)
  • shop_phone — VARCHAR(20)
  • shop_number — VARCHAR(10)
  • category — ENUM('food','cafe','beauty','fashion','book','bakery)'
  • shop_image — longtext

쿠폰 (coupons)

  • coupons_id — BIGINT — 기본 키 — NOT NULL
  • user_id — VARCHAR(20) — 외래 키 → 사용자.user_id — NOT NULL
  • shop_id — VARCHAR(50) — 외래 키 → 소상공인.shop_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • coupon_image — longtext — NOT NULL
  • number_limit — INT
  • number_used — INT
  • expiration_date — DATETIME
  • creation_date — DATETIME
  • coupons_status — ENUM('active','expired')

쿠폰후기 (review)

  • reviews_id — INT — 기본 키 — NOT NULL
  • coupons_id — BIGINT — 외래 키 → 쿠폰.coupons_id — NOT NULL
  • user_id — VARCHAR(20) — 외래 키 → 쿠폰.user_id — NOT NULL
  • shop_id — VARCHAR(50) — 외래 키 → 쿠폰.shop_id — NOT NULL
  • review_contents — VARCHAR(2048)
  • reviews_status — ENUM('visible','hidden')