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