헤이집
테이블 (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