Prop_tech

Tables (17)

Account (은행계좌 정보)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — VARCAHR — Foreign key → User.id — NOT NULL
  • description (Field) — VARCHAR
  • account (Field2) — VARCAHR
  • bankName (Field8) — VARCHAR
  • accountState (Field4) — VARCHAR
  • useDate (Field5) — DATE
  • regDate (Field6) — DATE
  • modiDate (Field7) — DATE

Alert (시스템 알림)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • message (Field) — VARCHAR
  • receive_user_id (Field3) — BIGINT
  • sand_date (Field4) — DATE
  • read_date (Field5) — DATE

Associate (주택조합 정보)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR
  • associate_state (Field2) — VARCHAR
  • operateFeeRatio (Field3) — NUMBERRIC
  • endExpectDate (Field7) — DATE
  • endRealDate (Field8) — DATE
  • city (Field9) — VACAHAR
  • state (Field10) — VACAHAR
  • address (Field11) — VACAHAR

Claim_prop (납입금 요구 정보)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • payment (Field3) — BIGINT
  • round (Field4) — INT
  • regDate (Field) — DATE
  • modiDate (Field2) — DATE
  • description (Field5) — VARCHAR
  • sale_prop_id (Key2) — BIGINT — Foreign key → Sale_prop.id — NOT NULL

Company (회사(시공사) 정보)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • ceoName (Field) — VARCHAR
  • bizRegNum (Field2) — VARCHAR
  • adress (Field3) — VARCHAR
  • zipCode (Field4) — VARCHAR
  • establishDate (Field5) — DATE

Locate_Pos (지도상 토지 좌표)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • xPos (Field) — NUMBERRIC
  • yPos (Field2) — NUMBERRIC
  • zPos (Field3) — NUMBERRIC
  • orderCount (Field4) — INT
  • purchase_prop_id (Key2) — BIGINT — Foreign key → purchase_prop.id — NOT NULL

Login_IP (로그인 IP 기록)

  • Key — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
  • IP (Field) — VARCHAR
  • regDate (Field2) — DATE
  • modiDate (Field3) — DATE
  • is_active (Field4) — BIT

Login_history (로그인 기록)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — VARCHAR — Foreign key → User.id — NOT NULL
  • loginDate (Field) — DATE
  • isLogin (Field3) — BIT

Messagge (사용자간 메세지)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • message (Field) — VARCHAR
  • sand_user_id (Field2) — BIGINT
  • receive_user_id (Field3) — BIGINT
  • sand_date (Field4) — DATE
  • read_date (Field5) — DATE

Prop_Price (가격변동 정보)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • price (Field) — BIGINT
  • regDate (Field2) — DATE
  • modiDate (Field5) — DATE
  • regIp (Field3) — VARCHAR
  • description (Field4) — VARCHAR
  • purchase_prop_id (Key2) — BIGINT — Foreign key → purchase_prop.id — NOT NULL

Receipt (납입금 제출 정보)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • payment (Field) — BIGINT
  • paymentDate (Field2) — DATE
  • buyerIp (Field3) — VARCAHR
  • ReceiptState (Field4)
  • user_id (Key3) — VARCHAR — Foreign key → User.id — NOT NULL
  • claim_id (Key2) — BIGINT — Foreign key → Claim_prop.id — NOT NULL

Sale_prop (분양 부동산 정보)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • addressDetail (Field) — VARCHAR
  • sale Round (Field2) — INT
  • regDate (Field3) — DATE
  • modiDate (Field4) — DATE
  • associate_id (Key2) — BIGINT — Foreign key → Associate.id — NOT NULL

Staff (조합 관리자 정보)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • regDate (Field) — DATE
  • modiDate (Field2) — DATE
  • staff_Role (Field4) — VARCHAR
  • associate_id (_id) — BIGINT — Foreign key → Associate.id — NOT NULL
  • user_id (Key2) — VARCHAR — Foreign key → User.id — NOT NULL

User (사용자 정보)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • company_id (Key2) — BIGINT — Foreign key → Company.id — NOT NULL
  • password (Field) — VARCHAR
  • name (Field2) — VARCHAR
  • email (Field3) — VARCHAR
  • profileImg (Field11) — VARCHAR
  • user_role (Field4) — VARCHAR
  • user_state (Field10) — VARCHAR
  • retiredDate (Field6) — DATE
  • regDate (Field7) — DATE
  • modiDate (Field8) — DATE
  • modiPwdDate (Field12) — DATE
  • phoneNumber (Field5) — VARCHAR
  • userId (Field9) — VARCHAR
  • provider (Field13) — VARCHAR
  • provider_id (Field14) — VARCHAR

WEB_MENU (권한별 사용 가능 메뉴)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • user_role (Field) — VARCHAR
  • name (Field2) — VARCHAR
  • url (Field3) — VARCHAR
  • parent_id (Field4) — BIGINT
  • order_seq (Field5) — INT
  • regDate (Field6) — DATE
  • modiDate (Field7) — DATE

owned_history (소요자 변경 정보)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • regDate (Field) — DATE
  • modiDate (Field2) — DATE
  • owned_state (Field3) — VARCHAR
  • user_id (Key2) — VARCHAR — Foreign key → User.id — NOT NULL
  • Sale_prop_id (Key3) — BIGINT — Foreign key → Sale_prop.id — NOT NULL

purchase_prop (구매 토지 정보)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • city (Field) — VARCHAR
  • state (Field2) — VARCHAR
  • zipCode (Field3) — VARCHAR
  • address (Field4) — VARCAHR
  • addressDetail (Field5) — VARCAHR
  • purchase_date (Field8) — DATE
  • prop_type (Field6) — VARCHAR
  • associatei_d (Key2) — BIGINT — Foreign key → Associate.id — NOT NULL