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)