sidEGo
Tables (10)
Applicant (Untitled8)
- id (Key) — Primary key — NOT NULL
- project_id (Key2) — Foreign key → project.id — NOT NULL
- user_id (id) — Long — Foreign key → User.id — NOT NULL
- status (Field)
- content (Field2)
- career (Field3)
User (Untitled)
- id — Long — Primary key — NOT NULL
- username (Field)
- password (Field2)
- profile_img (Field3)
- name (Field4)
- cash (Field5)
- profit (Field6)
- ticket_count (Field7)
- like (Field8)
- email (Field9)
- introduction (Field10)
attachment (Untitled7)
- id (Key) — Primary key — NOT NULL
- paper_id (Key2) — Foreign key → paper.id — NOT NULL
- title (Field)
- url (Field2)
cupon (Untitled6)
- id (Key) — Primary key — NOT NULL
- user_id (id) — Long — Foreign key → User.id — NOT NULL
- percent (Field)
- is_used (Field2)
- used_at (Field3)
like (Untitled2)
- id (Key) — Primary key — NOT NULL
- project_id (id) — Long — Foreign key → User.id — NOT NULL
- user_id (User_id) — Long — Foreign key → project.user_id — NOT NULL
log (Untitled9)
- id (Key) — Primary key — NOT NULL
- user_id (id) — Long — Foreign key → User.id — NOT NULL
- projetct_id (Key2) — Foreign key → project.id — NOT NULL
- type (Field)
- status (Field2)
- Field3
paper (Untitled4)
- id (Key) — Primary key — NOT NULL
- user_id (id) — Long — Foreign key → User.id — NOT NULL
- category (Field)
- title (Field2)
- title_short (Field3)
- description (Field4)
- description_short (Field5)
- price (Field6)
point_log (Untitled10)
- id (Key) — Primary key — NOT NULL
- id (user_id) — Long — Foreign key → User.id — NOT NULL
- title (Field)
- point (Field2)
project (Untitled3)
- id (Key) — Primary key — NOT NULL
- user_id (User_id) — Long — Foreign key → User.id — NOT NULL
- category (Field)
- title (Field2)
- title_short (Field3)
- member_count (Field4)
- member_count_max (Field5)
- date_end (Field7)
- thumbnail (Field8)
- body_title (Field9)
- body_goal (Field10)
- body_plan (Field11)
- body_style (Field12)
- body_requried (Field13)
- view_count (Field15)
review (Untitled5)
- Key — Primary key — NOT NULL
- project_id (id) — Long — Foreign key → User.id — NOT NULL
- user_id (User_id) — Long — Foreign key → project.user_id — NOT NULL
- content (Field)
- score (Field2)