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')