헤이집

테이블 (24)

address (Untitled19)

  • id (Key) — int — 기본 키 — NOT NULL
  • sido (Field) — varchar(255) — NOT NULL
  • sigungu (Field2) — varchar(255) — NOT NULL
  • code (Field3) — varchar(255) — NOT NULL

availableOption (Untitled22)

  • id (Key) — 기본 키 — NOT NULL
  • slotId (Key2) — int — 외래 키 → slot.id — NOT NULL
  • optionId (Key3) — int — 외래 키 → option.id — NOT NULL
  • Field (Field7) — 외래 키

building (Untitled8)

  • id — int — 기본 키 — NOT NULL
  • departmentId (id3) — int — 외래 키 → department.id — NOT NULL
  • addressId (id2) — int — 외래 키 → buildingAddress.id — NOT NULL
  • buildingName (Field) — varchar(255)
  • propertyCount (Field2) — int — NOT NULL
  • parkingCount (Field3) — dobule — NOT NULL
  • buildDate (Field4) — varchar(255) — NOT NULL
  • hasEV (Field5) — boolean — NOT NULL
  • approveDate (Field6) — varchar(255) — NOT NULL
  • Field7

buildingAddress (Untitled7)

  • id — int — 기본 키 — NOT NULL
  • baseId (Key) — int — 외래 키 → address.id — NOT NULL
  • road (Field) — varchar(255) — NOT NULL
  • mainBun (Field2) — int — NOT NULL
  • subBun (Field3) — int

department (Untitled10)

  • id — int — 기본 키 — NOT NULL
  • addressId (id2) — int — 외래 키 → landAddress.id — NOT NULL
  • typeId (Key) — int — 외래 키 → departmentType.id — NOT NULL
  • departmentName (Field) — varchar(255)

departmentType (Untitled9)

  • id (Key) — int — 기본 키 — NOT NULL
  • type (Field) — varchar(255) — NOT NULL

floor (Untitled12)

  • id — int — 기본 키 — NOT NULL
  • buildingId (id2) — int — 외래 키 → building.id — NOT NULL
  • typeId (Key2) — int — 외래 키 → floorType.id — NOT NULL
  • floorNumber (Field) — int — NOT NULL

floorType (Untitled20)

  • id (Key) — int — 기본 키 — NOT NULL
  • type (Field) — varchar(255) — NOT NULL

historyType (Untitled24)

  • id (Key) — int — 기본 키 — NOT NULL
  • id (Key2) — int — 외래 키 → teamMemeberHistory.id — NOT NULL
  • type (Field) — varchar(255) — NOT NULL

image (Untitled14)

  • id (Key) — int — 기본 키 — NOT NULL
  • slotId (Key2) — int — 외래 키 → slot.id — NOT NULL
  • id — int — 외래 키 → slot.propertId — NOT NULL
  • id (id4) — int — 외래 키 → slot.priceid — NOT NULL
  • Field (Field7) — 외래 키
  • src (Field) — varchar(255) — NOT NULL
  • deletedAt (Field2) — timestamp

landAddress (Untitled6)

  • id — int — 기본 키 — NOT NULL
  • baseId (Key) — int — 외래 키 → address.id — NOT NULL
  • dong (Field) — varchar(255) — NOT NULL
  • hdong (Field2) — varchar(255) — NOT NULL
  • bonbun (Field3) — int — NOT NULL
  • bubun (Field4) — int

option (Untitled21)

  • id (Key) — int — 기본 키 — NOT NULL
  • option (Field) — varchar(255) — NOT NULL

paymentinfo (Untitled13)

  • id — int — 기본 키 — NOT NULL
  • teamId — int — 외래 키 → team.id — NOT NULL
  • isVaild — boolean — NOT NULL
  • expiredAt (Field) — timeStamp — NOT NULL

price (Untitled11)

  • id — int — 기본 키 — NOT NULL
  • typeId (Key) — int — 외래 키 → priceType.id — NOT NULL
  • deposit — int
  • monthly — int
  • loanAmount (Field) — int

priceType (Untitled15)

  • id (Key) — int — 기본 키 — NOT NULL
  • type (Field) — varchar(255) — NOT NULL

property (Untitled5)

  • id — int — 기본 키 — NOT NULL
  • floorId (id2) — int — 외래 키 → floor.id — NOT NULL
  • roomCount (Field) — int — NOT NULL
  • bathroomCount (Field2) — int — NOT NULL
  • ho (Field3) — varchar(255)
  • isWhloeFloor (Field4) — boolean — NOT NULL
  • facingDirection (Field5) — varchar(10) — NOT NULL
  • facingDirectionPoint (Field6) — varchar(10 — NOT NULL
  • rentalArea (Field7) — double — NOT NULL
  • usingArea (Field8) — double — NOT NULL
  • isRoomOpen (Field9) — boolean — NOT NULL
  • entranceType (Field10) — varchar(30) — NOT NULL
  • heatingType (Field11) — varchar(30) — NOT NULL
  • hasVeranda (Field12) — boolean — NOT NULL

slot (Untitled18)

  • id (Key) — int — 기본 키 — NOT NULL
  • propertId (id) — int — 외래 키 → property.id — NOT NULL
  • teamId (id2) — int — 외래 키 → team.id — NOT NULL
  • userid (id3) — int — 외래 키 → user.id — NOT NULL
  • priceid (id4) — int — 외래 키 → price.id — NOT NULL
  • moveInDate (Field) — varchar(255)
  • memo (Field2) — text
  • canParking (Field3) — boolean — NOT NULL
  • title (Field4) — text
  • content (Field5) — text
  • contactType (Field6) — varchar(255)

team (Untitled)

  • id — int — 기본 키 — NOT NULL
  • statusId (Key) — int — 외래 키 → teamStatus.id — NOT NULL
  • name — varchar(255) — NOT NULL
  • location — varchar(255)
  • isVaild (isValid) — boolean — NOT NULL
  • brn (Field) — varchar(255) — NOT NULL

teamMemeberHistory (Untitled23)

  • id (Key) — int — 기본 키 — NOT NULL
  • teamId (id) — int — 외래 키 → team.id — NOT NULL
  • reason (Field) — text

teamStatus (Untitled16)

  • id (Key) — int — 기본 키 — NOT NULL
  • status (Field) — varchar(255) — NOT NULL

template (Untitled17)

  • id (Key) — int — 기본 키 — NOT NULL
  • userId (id) — int — 외래 키 → user.id — NOT NULL
  • content (Field) — text — NOT NULL
  • deletedAt (Field2) — timestamp

token (Untitled3)

  • id — int — 기본 키 — NOT NULL
  • teamId — int — 외래 키 → team.id — NOT NULL
  • typeId — int — 외래 키 → tokenType.id — NOT NULL
  • id (Key) — int — 외래 키 → team.statusId — NOT NULL
  • token — varchar(255) — NOT NULL
  • isValid — boolean — NOT NULL

tokenType (Untitled4)

  • id — int — 기본 키 — NOT NULL
  • type — varchar(255) — NOT NULL
  • isVaild — boolean — NOT NULL

user (Untitled2)

  • id — int — 기본 키 — NOT NULL
  • teamId — int — 외래 키 → team.id — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • isChief — boolean — NOT NULL
  • name — varchar(255) — NOT NULL
  • isVaild — booelan — NOT NULL