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