Danpoong

Tables (5)

Apt (부동산)

  • aptiD (Key) — int — Primary key — NOT NULL
  • umdNm (Field2) — String
  • aptNm (Field3) — String
  • jibun (Field4) — String
  • excluUseAr (Field5) — String
  • deposit (Field6) — int
  • monthlyRent (Field7) — int
  • contractType (Field8) — String

Category (업종)

  • categoryID (Key2) — int — Primary key — NOT NULL
  • companyID (Key) — int — Foreign key → Company.companyID — NOT NULL
  • category (Field) — string

Company (기업)

  • companyID (Key) — int — Primary key — NOT NULL
  • companyName (Field) — String
  • companyInfoPage (Field4) — String
  • detailLoc (Field2) — String

Location (기업 위치)

  • companyID (Key) — int — Foreign key → Company.companyID — NOT NULL
  • location (Field) — string

Type (기업 형태)

  • companyID (Key) — int — Foreign key → Company.companyID — NOT NULL
  • type (Field) — string