mini
Tables (14)
Activities (Untitled6)
- Key (activities_id) — Primary key — NOT NULL
- Key (actcategory_id) — Foreign key → activitycategory.Key — NOT NULL
- title (Field)
- description (Field2)
- roomId (Field3)
- max (Field4)
- people (Field5)
- d-day (Field6)
User (Untitled)
- Key (user_id) — Text — Primary key — NOT NULL
- email
- password
- phone
- nickname
- address (Field)
activitycategory (Untitled7)
- Key (actcategory_id) — Primary key — NOT NULL
- name (Field)
activitycomment (Untitled9)
- Key — Primary key — NOT NULL
- Key (activities_id) — Foreign key → Activities.Key — NOT NULL
- Key (actcategory_id) — Foreign key → Activities.Key — NOT NULL
- Key (user_id) — Text — Foreign key → User.Key — NOT NULL
- content (Field)
activityjoin (Untitled8)
- Key — Primary key — NOT NULL
- Key (user_id) — Text — Foreign key → User.Key — NOT NULL
- Key (activities_id) — Foreign key → Activities.Key — NOT NULL
- Key (actcategory_id) — Foreign key → Activities.Key — NOT NULL
- admiin (Field)
chat (Untitled10)
- Key — Primary key — NOT NULL
- Key (user_id) — Text — Foreign key → User.Key — NOT NULL
- roomId (Field)
- Key (user_id2) — Text — Foreign key → User.Key — NOT NULL
donation (Untitled12)
- Key (donation_id) — Primary key — NOT NULL
- Key (user_id) — Text — Foreign key → User.Key — NOT NULL
- title (Field)
- url (Field2)
- description (Field3)
- Field4
donationcomment (Untitled13)
- Key — Primary key — NOT NULL
- Key (donation_id) — Foreign key → donation.Key — NOT NULL
- Key (user_id) — Text — Foreign key → donation.Key — NOT NULL
- Key (user_id2) — Text — Foreign key → User.Key — NOT NULL
- content (Field)
donationtr (Untitled14)
- Key — Primary key — NOT NULL
- Key (donation_id) — Foreign key → donation.Key — NOT NULL
- Key (user_id) — Text — Foreign key → donation.Key — NOT NULL
- Key (user_id2) — Text — Foreign key → User.Key — NOT NULL
- impuid (Field)
- amount (Field2)
- status (Field3)
market (Untitled2)
- Key (market_id) — Text — Primary key — NOT NULL
- Key (Category_id) — Text — Foreign key → marketcategory.Key — NOT NULL
- Key (user_id) — Text — Foreign key → User.Key — NOT NULL
- title
- description
- like
- score (Field3)
- ascore (Field4)
marketcategory (Untitled3)
- Key (Category_id) — Text — Primary key — NOT NULL
- name
marketcomment (Untitled5)
- Key (productcomment_id) — Primary key — NOT NULL
- Key (user_id) — Text — Foreign key → User.Key — NOT NULL
- Key (product_id) — Text — Foreign key → market.Key — NOT NULL
- Key (Category_id) — Text — Foreign key → market.Key — NOT NULL
- Key (user_id2) — Text — Foreign key → market.Key — NOT NULL
- Field
marketlike (Untitled4)
- Key (productlike_id) — Text — Primary key — NOT NULL
- Key (product_id) — Text — Foreign key → market.Key — NOT NULL
- Key (Category_id) — Text — Foreign key → market.Key — NOT NULL
- Key (user_id) — Text — Foreign key → market.Key — NOT NULL
- Key (user_id2) — Text — Foreign key → User.Key — NOT NULL
- like — boolean
markettr (Untitled11)
- Key — Primary key — NOT NULL
- Key (user_id) — Text — Foreign key → User.Key — NOT NULL
- Key (product_id) — Text — Foreign key → market.Key — NOT NULL
- Key (Category_id) — Text — Foreign key → market.Key — NOT NULL
- Key (user_id2) — Text — Foreign key → market.Key — NOT NULL
- impuid (Field)
- amount (Field2)
- status (Field3)