MINI 8-B-3

Tables (4)

Card (card)

  • id (card_id) — int — Primary key — NOT NULL
  • id (member_id) — type — Foreign key → Member.id — NOT NULL
  • title — String
  • content — String
  • nickname (test) — String
  • createdAt (Field)
  • modifiedAt (Field2)
  • imgUrl (url) — String
  • star (별점) — int
  • place (장소) — String
  • ages (나이대) — String

Comment (comment)

  • id (comment_id) — int — Primary key — NOT NULL
  • id (member_id) — type — Foreign key → Member.id — NOT NULL
  • id (card_id) — int — Foreign key → Card.id — NOT NULL
  • nickname — String
  • content — String
  • createdAt (date)
  • modifiedAt (ddate)

File (file)

  • id (Key) — Primary key — NOT NULL
  • Url (url) — String

Member (member)

  • id (member_id) — type — Primary key — NOT NULL
  • nickname — String
  • password — String
  • age — String
  • gender — String