Db Schema

Collections

Mongoose schema

const user = new Schema(
  {
    authName: String,
    authId: Number,
  },
);

const accountBook = new Schema(
  {
    accountBookId: Number,
    accountBookName: String,
    accountBookAuthorizedUsers: [String],
  },
);

const transactions = new Schema(
  {
    accountBookId: Number,
    date: Date,
    category: String,
    paymentMethod: String,
    description: String,
    cost: Number,
    tag: [String],
    imageUrl: String,
    author: String,
  },
);

const paymentMethod = new Schema(
  {
    name: String
  },
);

const category = new Schema(
  {
    name: String
  },
);

const tag = new Schema(
  {
    name: String
  },
);

Db Collection sample

user

const user = [{
  "_id": 1,
  "authName": "name",
  "authId": 1234,
},]

accountBook

const accountBook = [{
  "_id": 1,
  "accountBookId": 1,
  "accountBookName": 'Name',
  "accountBookAuthorizedUsers": ['Name'],
},]

transactions

const transactions = [{
  "_id": 1,
  "accountBookId": 1,
  "date": "2020-01-15 14:20",
  "category": "food",
  "card": "naver card",
  "description": "분식집에서 떡볶이 먹엇으~",
  "cost": 20000,
  "tag": ["분식집", "떡볶이"],
  "imageUrl": "https://www.asiatime.co.kr/news/data/20191217/p1065600532377147_587_thum.jpg",
  "author": "name",
},]

account

const account = [{
  "_id": 1,
  "name": "현대카드",
},{
  "_id": 2,
  "name": "네이버페이"
},]

category

const category = [{
  "_id": 1,
  "name": "food"
}, {
  "_id": 2,
  "name": "transportation"
}, {
  "_id": 3,
  "name": "education"
},]

tag

const tag = [{
  "_id": 1,
  "name": "분식집"
}, {
  "_id": 1,
  "name": "떡볶이"
},]