database

Tables (14)

account_emailaddress (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • id (Key2) — int — Foreign key → auth_user.id — NOT NULL
  • email (Field) — varchar(254)
  • verified (Field2) — bool
  • primary (Field3) — bool
  • user_id (Field4) — int

auth_user (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • password (Field) — varchar(128)
  • last_login (Field2) — datetime
  • is_superuser (Field3) — bool
  • username (Field4) — varchar(150)
  • email (Field5) — varchar(254)
  • is_active (Field6) — bool
  • date_joined (Field7) — datetime
  • first_name (Field8) — varchar(150)
  • id (Key2) — int — Foreign key → board_post.id — NOT NULL
  • id (Key3) — int — Foreign key → board_comment.id — NOT NULL

board_category (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • slug (Field2) — varchar(200)
  • id (Key2) — int — Foreign key → board_post.id — NOT NULL

board_comment (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • content (Field) — text
  • created_at (Field2) — datetime
  • modified_at (Field3) — datetime
  • author_id (Field4) — int
  • post_id (Field5) — bigint
  • id (Key2) — int — Foreign key → board_post.id — NOT NULL

board_post (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • title (Field) — varchar(100)
  • created_at (Field2) — datetime
  • updated_At (Field3) — datetime
  • upload_image (Field4) — varchar(100)
  • author_id (Field5) — int
  • category_id (Field6) — bigint
  • content (Field7) — text

django_admin_log (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • action_time (Field) — datetime
  • object_id (Field2) — text
  • object_repr (Field3) — varchar(200)
  • change_message (Field4) — text
  • user_id (Field5) — int
  • action_fiag (Field6) — smallint

django_content_type (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • id (Key2) — int — Foreign key → django_site.id — NOT NULL
  • id (Key22) — int — Foreign key → django_site.id — NOT NULL
  • app_label (Field) — varchar(100)
  • model (Field2) — varchar(100) — NOT NULL

django_session (Untitled9)

  • session_key (Key) — varchar(40) — Primary key — NOT NULL
  • session_data (Field) — text
  • expire_date (Field2) — datetime
  • id (Key2) — int — Foreign key → django_admin_log.id — NOT NULL

django_site (Untitled10)

  • id (Key) — int — Primary key — NOT NULL
  • id (Key2) — int — Foreign key → django_admin_log.id — NOT NULL
  • name (Field) — varchar(50)
  • domain (Field2) — varchar(100)

map_restaurants (Untitled14)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • kinds (Field2) — varchar(20)
  • review (Field3) — varchar(20)
  • web_link (Field4) — varchar(200)
  • address (Field5) — varchar(100)
  • lat (Field6) — real
  • lng (Field7) — real
  • category (Field8) — varchar(20)
  • score (Field9) — real

socialaccount_socialaccount (Untitled13)

  • id (Key) — int — Primary key — NOT NULL
  • id (Key2) — int — Foreign key → socialaccount_socialapp.id — NOT NULL
  • provider (Field) — varchar(30)
  • uid (Field2) — varchar(191)
  • last_login (Field3) — datetime
  • date_joined (Field4) — datetime
  • extra_data (Field5) — text
  • user_id (Field6) — int

socialaccount_socialapp (Untitled8)

  • id (Key) — int — Primary key — NOT NULL
  • provider (Field) — varchar(30)
  • name (Field2) — varchar(40)
  • client_id (Field3) — varchar(191)
  • secret (Field4) — varchar(191)
  • key (Field5) — varchar(191)

socialaccount_socialapp_sites (Untitled11)

  • id (Key) — int — Primary key — NOT NULL
  • id (Key2) — int — Foreign key → socialaccount_socialapp.id — NOT NULL
  • socialapp_id (Field) — int
  • site_id (Field2) — int
  • id (Key3) — int — Foreign key → django_site.id — NOT NULL
  • id (Key22) — int — Foreign key → django_site.id — NOT NULL

socialacocunt_socialtoken (Untitled12)

  • id (Key) — int — Primary key — NOT NULL
  • id (Key2) — int — Foreign key → socialaccount_socialapp.id — NOT NULL
  • token (Field) — text
  • token_secret (Field2) — text
  • expires_at (Field3) — datetime
  • account_id (Field4) — bigint
  • app_id (Field5) — bigint