nu
Tables (7)
Funding
- id — INT
- title — VARCHAR(255)
- description — TEXT
- goalMoney — INT
- fundedMoney — INT
- deadlineDate — DATETIME
- CreatedAt — DATETIME
- UpdatedAt — DATETIME
- userId — INT
- detailRegion — VARCHAR(30)
- completeDueDate — DATETIME
- applicantComment — VARCHAR(500) — ARCHAR(500
- privacyAgreement — BOOLEAN
FundingComment
- id — INT
- fundingId — INT
- userId — INT
- comment — VARCHAR(500) — ARCHAR(500
- createdAt — DATETIME
- updatedAt — DATETIME
JoinedUser
- id — INT
- FundingsId — INT
- UserId — INT
- fundedMoney — INT
- CreatedAt — DATETIME(6)
- UpdatedAt — DATETIME(6)
Megazine
- id — INT
- UserId — INT
- title — VARCHAR(255)
- body — VARCHAR(255)
- CreatedAt — DATETIME(6)
- photo — VARCHAR(255)
- link — VARCHAR(255)
Photo
- id — INT
- FundingId — INT
- url — VARCHAR(255)
Session
- id — VARCHAR(255)
- sid — VARCHAR(255)
- data — VARCHAR(512)
- expiresAt — DATETIME
User
- id — INT
- userId — VARCHAR(100)
- name — VARCHAR(100)
- email — VARCHAR(255)
- password — VARCHAR(100)
- status — VARCHAR(255)
- inactiveDate — DATETIME(6)
- CreatedAt — DATETIME(6)
- region — ENUM('SEOUL', 'INCHEON_GYEONGGI', 'GYEONGSANG', 'CHUNGCHEONG', 'GANGWON', 'JEOLLA', 'JEJU')