Final
Tables (3)
Coupon (제작)
- id (Key) — PK — Primary key — NOT NULL
- coupon_type (Field) — char
- coupon_code (Field2) — char
- is_target (Field10) — boolean
- coupon_name (Field9) — char
- point (Field3) — float
- content (Field6) — text
- duration (Field5) — int
- expiry_date (Field11) — dateTime
- created_at (Field7) — dateTime
- updated_at (Field8) — dateTime
- deleted (Field12) — boolean
Coupon Manager (메니져)
- id (Key) — PK — Primary key — NOT NULL
- coupon (Key2) — PK — Foreign key → Coupon.id — NOT NULL
- user (Key3) — Foreign key → User.id — NOT NULL
- valid_from (Field3)
- valid_until (Field4)
- is_used (Field6) — boolean
- used_date (Field7) — dateTime
- created_at (Field)
- upadated_at (Field2)
- deleted (Field5) — boolean
User (Untitled3)
- id (Key) — Primary key — NOT NULL
- email (Field5) — char
- password (Field8)
- name (Field2) — char
- tel (Field4) — char
- co_tel (Field)
- manager_name (Field3)
- manager_tel (Field6) — deciaml
- registration_num (Field7)
- co_registration_num (Field9)
- zip_code (Field10)
- street_name (Field11)
- lot_name (Field12)
- detailed_addr (Field13)
- subscribe_email (Field14)
- subscribe_kakao (Field15)
- subscribe_sms (Field16)
- sms_notification (Field17)
- now_point (Field18)
- now_balance (Field19)
- user_recommend (Field20)
- subscription (Field21)
- grade (Field22)
- created_at (Field23)
- level (Field24)
- blocked_email (Field25)
- blocked_time (Field26)
- login_count (Field27)
- deleted (Field28)
- social_id (Field29)