enjoytrip

Tables (8)

Article

  • articleIdx — int — Primary key — NOT NULL
  • hit — int
  • likeCount — int
  • content — varchar(500)
  • placeIdx — int
  • createAt — timestamp
  • updateAt — timestamp
  • deleteAt — timestamp
  • userIdx — int — Foreign key → User.userIdx — NOT NULL

Comment

  • commentIdx — int — Primary key — NOT NULL
  • content — varchar(200)
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • articleIdx — int — Foreign key → Article.articleIdx — NOT NULL

Img

  • imgIdx — int — Primary key — NOT NULL
  • imgUrl — varchar(200)
  • articleIdx — int — Foreign key → Article.articleIdx — NOT NULL

Like

  • likeIdx — int — Primary key — NOT NULL
  • planIdx — int — Foreign key → Plan.planIdx — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL

Place

  • placeIdx — int — Primary key — NOT NULL
  • lat — double
  • lon — double
  • createAt (creatAt) — timestamp
  • updateAt — timesatmp
  • deleteAt — timestamp

Plan

  • planIdx — int — Primary key — NOT NULL
  • region (regjon) — varchar(30)
  • startDate — timestamp
  • period — int
  • isOpened — boolean
  • createAt — timestamp
  • updateAt — timestamp
  • deleteAt — timestamp
  • userIdx — int — Foreign key → User.userIdx — NOT NULL

User

  • userIdx — int — Primary key — NOT NULL
  • userId — varchar(12)
  • userPwd — varchar(500)
  • userEmail — varchar(30)
  • userName — varchar(10)
  • createAt — timestamp
  • updateAt — timestamp
  • deleteAt — timestamp

planOrder (PlanOrder)

  • planOrderIdx — int — Primary key — NOT NULL
  • planDate — timestamp
  • placeOrder — int
  • planIdx — int — Foreign key → Plan.planIdx — NOT NULL
  • placeIdx (placeIdx2) — int — Foreign key → Place.placeIdx — NOT NULL