pj
Tables (6)
NFT (NFT관련)
- token_id (Key) — int — Primary key — NOT NULL
- token_url (Field2) — string
- image_name (Field3) — string
- price (Field4) — int
- released (Field5) — date
- emotion (Field6) — stirng
- description (Field7) — string
- owner (unique) — string — Foreign key → User.user_id — NOT NULL
User (Untitled)
- user_id (A.i) — number — Primary key — NOT NULL
- email (unique) — string
- password (Field) — string
- nickname (Field2) — string
- refreshToken (Field3) — string
answer (답변)
- answer_id (Key) — number — Primary key — NOT NULL
- content (Field) — string
- created_at (Field2) — Date
- question_id (A.i2) — number — Foreign key → question.question_id — NOT NULL
- nickname (unique) — string — Foreign key → User.user_id — NOT NULL
basket (장바구니)
- basket_id (Key) — number — Primary key — NOT NULL
- source (Field) — string
- title (Field2) — string
- price (Field3) — Float
- user_id (A.i2) — number — Foreign key → User.user_id — NOT NULL
diary (일기)
- diary_id (Key) — number — Primary key — NOT NULL
- title (Field) — string
- content (Field2) — string
- date (Field3) — string
- emotion (Field4) — string
- weather (Field5) — string
- source (Field6) — string
- rate (Field7) — float
- created_at (Field8) — Date
- updated_at (Field9) — string
- user_id (A.i) — number — Foreign key → User.user_id — NOT NULL
question (질문)
- question_id (A.i) — number — Primary key — NOT NULL
- title (Field) — string
- content (Field2) — string
- isPrivate (Field3) — Boolean
- createdAt (Field4) — Date
- nickname (unique) — string — Foreign key → User.user_id — NOT NULL