to
Tables (5)
comments
- id — int — Primary key — NOT NULL
- content — varchar(255)
- user_id — int — Foreign key → users.id — NOT NULL
- funding_id — int — Foreign key → fundings.id — NOT NULL
fundings
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → users.id — NOT NULL
- title — varchar(10)
- description — varchar(500)
- goal_money — bigint
- funded_money — int
- deadline_date — datetime(6)
- photo_url — varchar(255)
- region — ENUM
- detail_address — varchar(30)
- complete_due_date — datetime(6)
- privacy_agreement — boolean
- status — boolean
megazines
- id — int — Primary key — NOT NULL
- title — varchar(255)
- body — varchar(255)
- photo — varchar(255)
- link — varchar(255)
user_fundings
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → users.id — NOT NULL
- funding_id — int — Foreign key → fundings.id — NOT NULL
- user_funded_money — bigint
users
- id — int — Primary key — NOT NULL
- user_id — varchar(100)
- password — varchar(100)
- region — ENUM