KW Partnership ERD
Tables (13)
BENEFIT
- benefit_id — BIGINT
- store_id — BIGINT — Foreign key → STORE.store_id
- description — TEXT
- is_school_wide — BOOLEAN
- start_date — DATE
- end_date — DATE
- is_active — BOOLEAN
BENEFIT_DEPARTMENT
- benefit_id — BIGINT — Foreign key → BENEFIT.benefit_id
- department_id — BIGINT — Foreign key → DEPARTMENT.department_id
BENEFIT_USAGE
- usage_id — BIGINT
- user_id — BIGINT — Foreign key → USER.user_id
- store_id — BIGINT — Foreign key → STORE.store_id
- benefit_id — BIGINT — Foreign key → BENEFIT.benefit_id
- used_at — TIMESTAMP
- status — VARCHAR
CATEGORY
- category_id — BIGINT
- name — VARCHAR
COLLEGE
- college_id — BIGINT
- name — VARCHAR
DEPARTMENT
- department_id — BIGINT
- college_id — BIGINT — Foreign key → COLLEGE.college_id
- name — VARCHAR
FAVORITE
- user_id — BIGINT — Foreign key → USER.user_id
- store_id — BIGINT — Foreign key → STORE.store_id
- created_at — TIMESTAMP
MENU
- menu_id — BIGINT
- store_id — BIGINT — Foreign key → STORE.store_id
- name — VARCHAR
- image_url — VARCHAR
- is_representative — BOOLEAN
- display_order — INT
OPERATOR_PROFILE
- user_id — BIGINT — Foreign key → USER.user_id
- store_id — BIGINT — Foreign key → STORE.store_id
- is_verified — BOOLEAN
- verified_at — TIMESTAMP
STORE
- store_id — BIGINT
- name — VARCHAR
- address — VARCHAR
- location — VARCHAR
- contact — VARCHAR
- thumbnail_url — VARCHAR
- is_reservable — BOOLEAN
- qr_token — VARCHAR
- created_at — TIMESTAMP
STORE_CATEGORY
- store_id — BIGINT — Foreign key → STORE.store_id
- category_id — BIGINT — Foreign key → CATEGORY.category_id
STUDENT_PROFILE
- user_id — BIGINT — Foreign key → USER.user_id
- college_id — BIGINT — Foreign key → COLLEGE.college_id
- department_id — BIGINT — Foreign key → DEPARTMENT.department_id
- student_number — VARCHAR
USER
- user_id — BIGINT
- email — VARCHAR
- password_hash — VARCHAR
- name — VARCHAR
- user_type — VARCHAR
- created_at — TIMESTAMP