mobile_new

Tables (10)

Board (article)

  • boardId (Key) — int — Primary key — NOT NULL
  • userId (Key2) — int — Foreign key → user.userId — NOT NULL
  • travelId (Key3) — int — Foreign key → travel.travelId — NOT NULL
  • writeDate (Field) — datetime
  • theme (Field2) — varchar(20)
  • title (Field3) — varchar(50)
  • content (Field4) — text
  • imageList (Field5) — Json

blackListToken (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • blacklist_at (Field) — datetime
  • token_id (Field2) — int

comment (Untitled5)

  • commentId (Key) — int — Primary key — NOT NULL
  • boardId (Key2) — int — Foreign key → Board.boardId — NOT NULL
  • userId (Key3) — int — Foreign key → user.userId — NOT NULL
  • content (Field) — Text
  • writeDate (Field2) — datetime
  • message (Field3)

emailValidate (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • email (Field) — varchat(50)
  • validateNumber (Field2) — int

firebase (profile)

  • firebaseId (Key) — int — Primary key — NOT NULL
  • userId (Key2) — int — Foreign key → user.userId — NOT NULL
  • fcmToken (Field) — varchar(500)

like_board (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • userId (Key2) — int — Foreign key → user.userId — NOT NULL
  • boardId (Key3) — int — Foreign key → Board.boardId — NOT NULL
  • travelId (Key32) — int — Foreign key → Board.travelId — NOT NULL

notification (Untitled4)

  • notificationID (Key) — int — Primary key — NOT NULL
  • msg (Field) — varchar(100)
  • notificationType (Field2) — int
  • createDate (Field3) — datetime
  • creator (Key2) — int — Foreign key → user.userId — NOT NULL
  • to (Key3) — int — Foreign key → user.userId — NOT NULL

place (Untitled)

  • placeId (Key) — int — Primary key — NOT NULL
  • travelId (Key2) — int — Foreign key → travel.travelId — NOT NULL
  • placeName (Field) — varchar(20)
  • saveDate (Field2) — datetime
  • memo (Field3) — varchar(50)
  • latitude (Field4) — float
  • longitude (Field5) — float
  • address (Field6)

travel (Untitled2)

  • travelId (Key) — int — Primary key — NOT NULL
  • location (Field) — Json
  • startDate (Field2) — datetime
  • endDate (Field3) — datetime

user (User)

  • userId (Key) — int — Primary key — NOT NULL
  • password (Field) — varchar(100)
  • email (Field2) — varchar(100
  • phone_number (Field3) — varchar(100)
  • nickname (Field4) — varchar(100)
  • profileImg (Field5) — varchar(100)
  • username (Field7) — varchar(100)
  • kakao_email (Field10) — varchar(100)
  • naver_email (Field6) — varchar(100)
  • google_email (Field11) — varchar(100)