erd

Tables (14)

Users (Untitled)

  • id (Key2) — not null — Primary key — NOT NULL
  • name (Field) — not null
  • username (Field2) — not null
  • email (Field3) — not null
  • password (Field4) — not null
  • created_at (Field5) — default
  • updated_at (Field6) — default

businessdistrictinfo (Untitled4)

  • no (Key) — Primary key — NOT NULL
  • shopname (Field)
  • localname (Field2)
  • code1 (Field3)
  • codename1 (Field4)
  • code2 (Field5)
  • codename2 (Field6)
  • code3 (Field7)
  • codename3 (Field8)
  • code4 (Field9)
  • codename4 (Field10)
  • citycode (Field11)
  • city (Field12)
  • gucode (Field13)
  • gu (Field14)
  • dongcode (Field15)
  • dong (Field16)
  • jibuaddress (Field17)
  • address (Field18)
  • oldpostcode (Field19)
  • postcode (Field20)
  • lng (Field21)
  • lat (Field22)

choices (Untitled5)

  • id (Key) — AI — Primary key — NOT NULL
  • text (Field) — not null
  • poll_id (Field2) — not null

guguncode (Untitled6)

  • gugun_code (Key) — Primary key — NOT NULL
  • gugun_name (Field) — not null

housedeal (Untitled7)

  • no (Key) — AI — Primary key — NOT NULL
  • dong (Field)
  • AptName (Field2)
  • code (Field3)
  • dealAmount (Field4)
  • buildYear (Field5)
  • dealYear (Field6)
  • dealMonth (Field7)
  • dealDay (Field8)
  • area (Field9)
  • floor (Field10)
  • jibun (Field11)
  • type (Field12)
  • rentMoney (Field13)

housedealforaptdeal (CopyOfUntitled7)

  • no (Key) — AI — Primary key — NOT NULL
  • dong (Field)
  • AptName (Field2)
  • code (Field3)
  • dealAmount (Field4)
  • buildYear (Field5)
  • dealYear (Field6)
  • dealMonth (Field7)
  • dealDay (Field8)
  • area (Field9)
  • floor (Field10)
  • jibun (Field11)
  • type (Field12)
  • rentMoney (Field13)

houseinfo (Untitled8)

  • no (Key) — Primary key — NOT NULL
  • dong (Field)
  • AptName (Field2)
  • code (Field3)
  • buildYear (Field4)
  • jibun (Field5)
  • lat (Field6)
  • lng (Field7)
  • img (Field8)

notice (Untitled2)

  • articleno (Key) — auto_increment — Primary key — NOT NULL
  • id (Field) — not null
  • subjcet (Field2) — not null
  • content (Field3) — not null
  • regtime (Field4) — not null

polls (Untitled9)

  • id (Key) — AI — Primary key — NOT NULL
  • question (Field)
  • expiration_date_time (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • created_by (Field5)
  • created_by (Field6)

qna_board (Untitled3)

  • qna_no (Key) — not null — Primary key — NOT NULL
  • qna_title (Field) — not null
  • qna_content (Field2) — not null
  • qna_userid (Field3) — not null
  • qna_datetime (Field4) — not null
  • reply_content (Field5)
  • reply_datetime (Field6)
  • reply_userid (Field7)

roles (Untitled10)

  • id (Key) — AI — Primary key — NOT NULL
  • name (Field)

sidocode (Untitled11)

  • sido_code (Key) — Primary key — NOT NULL
  • sido_name (Field)

user_roles (Untitled12)

  • user_id (Key) — Primary key — NOT NULL
  • role_id (Field)

votes (Untitled13)

  • id (Key) — AI — Primary key — NOT NULL
  • user_id (Field)
  • poll_id (Field2)
  • choice_id (Field3)
  • created_at (Field4)
  • updated_at (Field5)