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