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)