homebridge

Tables (8)

eventapplications (이벤트 지원 정보)

  • _id (Key) — objectId — Primary key — NOT NULL
  • user (Key2) — objectId — Foreign key → users._id — NOT NULL
  • event (Key3) — ObjectId — Foreign key → events._id — NOT NULL
  • name (Field) — String
  • phoneNumber (Field2) — String
  • paymentMethod (Field3) — String
  • paymentStatus (Field4) — String
  • email (Field5) — String
  • message (Field6) — String
  • applicationDate (Field7) — Date
  • __v (Field8) — Int32

events (이벤트)

  • _id (Key) — objectId — Primary key — NOT NULL
  • price (Field) — Int32
  • eventImages (Field2) — Array
  • productIntroduction (Field3) — String
  • productDescription (Field4) — String
  • departure (Field5) — Date
  • arrival (Field6) — Date
  • deadline (Field7) — Date
  • traffic (Field8) — String
  • ProductInformation (Field9) — String
  • schedules (Field10) — Array
  • registrationDate (Field11) — Date
  • __v (Field12) — Int32

frapplications (지원 정보)

  • _id (Key2) — objectId — Primary key — NOT NULL
  • user (Key) — objectId — Foreign key → users._id — NOT NULL
  • name (Field) — String
  • gender (Field2) — String
  • nationality (Field3) — String
  • address (Field4) — String
  • phoneNumber (Field5) — String
  • email (Field6) — String
  • message (Field7) — String
  • applicationDate (Field8) — Date
  • __v (Field9) — Int32

inquiry (문의)

  • _id (Key) — objectId — Primary key — NOT NULL
  • firstName (Field) — String
  • lastName (Field2) — String
  • phoneNumber (Field3) — String
  • email (Field4) — String
  • message (Field5) — String
  • applicationDate (Field6) — Date
  • __v (Field7) — Int32

jobApplication (채용 지원)

  • _id (Key) — objectId — Primary key — NOT NULL
  • user (Key2) — objectId — Foreign key → users._id — NOT NULL
  • job (Key3) — objectId — Foreign key → jobhouses._id — NOT NULL
  • name (Field) — String
  • gender (Field2) — String
  • nationality (Field3) — String
  • email (Field4) — String
  • applicationDate (Field5) — Date
  • __v (Field6) — int32

jobhouses (채용 정보)

  • _id (Key) — objectId — Primary key — NOT NULL
  • announcementName (Field) — String
  • companyName (Field2) — String
  • jobInfo (Field3) — String
  • salaryBenefit (Field4) — String
  • jobDatails (Field5) — String
  • deadline (Field6) — String
  • isAccomodated (Field7) — boolean
  • accomodationName (Field8) — String
  • jobHouseimages (Field9) — Array
  • generationInformation (Field10) — String
  • explanation (Field11) — String
  • externalFeatures (Field12) — String
  • contractInformation (Field13) — String
  • salary (Field14) — String
  • rent (Field15) — String
  • registerationDate (Field16) — Date
  • __v (Field17) — Int32

refund (환불)

  • _id (Key) — objectId — Primary key — NOT NULL
  • event (Key2) — objectId — Foreign key → eventapplications._id — NOT NULL
  • user (Key22) — objectId — Foreign key → eventapplications.user — NOT NULL
  • event (Key3) — ObjectId — Foreign key → eventapplications.event — NOT NULL
  • refundAmount (Field) — String
  • refundDate (Field2) — Date
  • accountNumber (Field3) — String
  • accountName (Field4) — String
  • bankName (Field5) — String
  • __v (Field6) — Int32

users (회원가입)

  • _id (Key) — objectId — Primary key — NOT NULL
  • userName (Field) — String
  • email (Field2) — String
  • password (Field3) — String
  • role (Field4) — String
  • emailConfirmed (Field5) — String
  • passwordResetToken (Field6) — String
  • passwordResetExpires (Field7) — Date
  • createAt (Field8) — Date
  • __v (Field9) — Int32