HeartConnection
Tables (4)
favorite
- id — string — Primary key — NOT NULL
- welfare_id — string — NOT NULL
- created_at — DateTime — NOT NULL
- user_id — string — Foreign key → users.id — NOT NULL
users
- id — string — Primary key — NOT NULL
- email — string — NOT NULL
- display_name — string
- created_time — DateTime
- address — string
- age — string
welfare
- id (Key) — string — Primary key — NOT NULL
- title — string
- detail — string
- department — string
- cycle — string
- offertype — string
- contact — string
- link — string
- types — string
- Eligibility — string
- criteria — string
- servicect — string
- howtoapply — string
- Field — string
- welfare_id — string — Foreign key → favorite.id — NOT NULL
welfarecenter
- id — string — Primary key — NOT NULL
- centerName — string
- centerTypes — string
- centerLocation — string
- centerUrl — string
- centerPic — string
- centerPoint — string — Foreign key → users.id — NOT NULL